yes/no data type custom

J

jen

Hi.
In the format box for a field, instead of Yes/No, I have entered
;"Male";"Female"
And I have changed the Lookup to Text box.
But in datasheet, only Female appears and cannot be modified. If I put Male
I get this message

-------The value you entered is not invalid for this field
For example, you may have entered text in a numeric field or a number that
is larger than the fieldsize setting permits -------

Can someone please tell me what I'm doing wrong.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OptionButton with Bookmark text output 1
Combo box in form error 4
Combo Box Errors 9
access, error message 1
How to calculate 1
Input Mask 1
Data Validation Query 1
Yes/No Trouble 5

Top