How to force the user to fill in values for yes/no fields ?

[pschrader]

Hi !
I'm using MS Access 2003.

I have a table with a number of yes/no fields.

When a new record is started,
I want the user
to explicitly specify a value for each of these fields,
e.g. by choosing one of two radio buttons associated with the field.

Now, it was no problem for me to arrange an option group with two suitable
radio buttons for each of these fields.
The user can then choose explicitly between yes and no.
However, all fields seem to have implicit values immediately after a new
record has been started.
Therefore, the new record can be stored in the db without the user making an
explicit choice.

What would you suggest to force the user to choose explicitly ?
Your kind help will be greatly appreciated.

Peter

 

[Linq Adams via AccessMonster.com]

When you set up an option group you're givien the choice of having a default
value or not. Apparently you opted to have a default value; you need to redo
them and opt for No Default. I'm not sure if there's a way to change it once
it's been created; maybe someone else here can say.

 

[SteveM]

Yes/No fields are either Yes or No. There is no other state for this field.

You could remove the Default Value from the Option Group.

Steve