Value of field not what it should be

[jamccarley]

I have a field in a form that the user can leave blank or if needed use the
dropdown box to choose "YES". My problem is that "NO" is not an option, but
when the form goes to the next record it throws a "2" into the field. The
field in the table is set to text, not yes/no. Would it still do this if the
user had to type "yes" and not use the value list that I have set up?


Thanks
Josh McCarley

 

[Jeanette Cunningham]

Hi Josh
Assuming that this is a single form and the dropdown is bound to a field in
the form's recordsource, you can create a combo that stores either Yes or
null in the field.
If you use the combo wizard and choose the option to type in the values you
want. Type dummy on the first line and Yes on the next line.
Now clear the word dummy from the first line to leave it blank.
This will give you a drop down with 2 choices, null or yes.
When you move to the next record, it should behave as any other drop down.

If you are using a continuous form and an unbound drop down, it will not
work as you intend.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia