Default value help

[access_denied]

Hello

Im hoping this should be very easy but I cant seem to figure it out.

I have made an Asset database and would love to have a flag next to each record as to whether its active or not.

Iv added a field called Active and set it as a Yes/No data type. I would like it to be Active (Yes) by default.
In the general properties it has a default value set as 0. I have tried to change that to things like 1, -1, Yes, =Yes etc but cant get it to work as going back to View mode the ticky boxes are not checked.

Thx

 

[plog]

It sounds like you have set the default properly (a few times). To set the default on a Yes/No box you simply put "True" in the default property in Table Design.

You just can't apply default value retroactively. Once data is in your table, that data isn't going to be affected by any new default values you set. The default value will only be applied to new data added.

To update data already in your table you would need to run an UPDATE query (http://office.microsoft.com/en-us/access-help/update-data-by-using-a-query-HA010076527.aspx) to set those values.

 

[vbaInet]

I have tried to change that to things like 1, -1, Yes

A default value of -1 or like plog said True (without the quotes) should do it but it will only affect newly added records.

 

[access_denied]

Ahh, bingo! I did not think about that, makes sense I guess.
Thx a bunch!