Option Group Defautst when set to 0, any suggestions

A

amissa

I am using an 6 option groups as a scoring system in a form. Option
1 is for needs improvement, 2 for Satisfactory, 3 for exceptional and
a 0 which stands for an 'NA'.
I used 0 for NA becasue I do not want to count it in the score. The
problem is that the NA now defaults and I do not want it to default.

Thanks,
amissa
 
O

Ofer Cohen

two locations to remove the default from
1. Open the table in design view, check the properties of the field where
this option is stored , if there is a 0 defined in the default propert remove
it

2. Open the form design view, select the option group properties and check
it properties if there is a 0 defined in the default properties.

If both set properly and it still gives 0 as default, check your code mybe
there is something that assign a 0.
 
A

amissa

I am under the impression that value of 0 will automatically default,
though nothing is set in the code or was not set to default. I do not
want any defauts and really want a message box to apper if an option
was not choosen, Because of the default to 0 a message does not trigger
ever, and the person filling in this form may have over looked the
question and did not ansere it because of the default.
 
Top