can't assign NULL

[mcnews]

is there some reason why the following line of code creates a "Value
you entered isn'tvalid for this field" error in Access 2000?
Form.CasminoAdded = Null

i do get the error with Access 2003.

 

[mcnews]

is there some reason why the following line of code creates a "Value
you entered isn'tvalid for this field" error in Access 2000?
Form.CasminoAdded = Null

i do get the error with Access 2003.

it's a Yes?No boolean field.

 

[Duane Hookom]

I wouldn't use a yes/no field if I wanted to store Null. An int field would
be more appropriate.

Also, we have no idea what "Form.CasminoAdded" is.

 

[mcnews]

I wouldn't use a yes/no field if I wanted to store Null. An int field would
be more appropriate.

Also, we have no idea what "Form.CasminoAdded" is.

i explained that it is a Yes/No boolean field.
users need to be able to check yes or no or set it to null.
null is not regarded as the same thing as no.

anyways, the problem was that it was trying to assign a value when the
control was disabled.
so it's fixed now.

 

[BruceM]

You may run into difficulties with Null in a Yes/No field. See
http://allenbrowne.com/bug-14.html

Other links on the page point to alternatives.