null value in yes\no field

G

Gil Lapid Shafriri

Hi,

I'm trying to force null value into yes\no field(the reason is not really
important)but it seems to be translated to false value. Is there any way to
force Jet to store null value on yes\no field ?

Thanks,

Gil
 
J

Jon Lewis

No. Your field needs to be of Integer type so you can store Null, 0 (No)
and -1 (Yes). Use a Check Box with its Triple State property set to Yes and
bind it to the Integer field to see how it works.

HTH
 

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

Assign a value of 1 for Yes 10
Text Box Problem 3
Null value in Yes/No field 2
Hiding Labels in Reports if Field Blank 2
Yes/No field in Query 1
Crosstab: <> values not showing 7
Help using Dlookup to find null value 2
Count of Yes with repeating fields 3

Top