default value of check box = yes ??

[hlkelly]

I have a table with a field data type yes/no. I need the default value to be 'yes'. I have updated the default value propery on the general tab to indicate 'yes' but it still says no.

anyone?

thanks.

heather

 

[dhookom]

A yes/no field store -1/True/Yes or 0/False/No. I would set the default to -1 rather than yes. Setting a default won't have any affect on existing records.

Duane
Hook'D on Access
MS Access MVP

 

[hlkelly]

ha...that's the problem. i was expecting a change to existing records. thank you!!

 

[Remou]

hlkelly

A good way of thanking people is to click:

Thank dhookom
for this valuable post!

 

[lespaul]

you can run an update query to correct existing records....

UPDATE TableName SET FieldName = -1 WHERE SomeOtherField = "SomeValue"

Leslie

Have you met Hardy Heron?