Null value handling in Access 2003

[raminriahi]

I have an application(front-end access 2000, back-end sql server 7). in one of my subforms i have a data-sheet bounded to an sql server table. in my network environment just 2 workstations have office 2003 suite prof. edition(on XP prof. OS). Only on these 2 machines, it keeps telling it can't insert Null value to a check-box field (which is null-able in server side) and it doesn't let user to navigate to next record, unless the user mark/unmark the field.
Any idea or suggestions will be much appreciated.

Thanks in advance,

 

[Page410]

I'm not sure that a check box can be assigned a null value in Access. A check box is a boolean control and will always be equal to one of two values (True or False, Yes or No, -1 or 0).

Weird that your users would not be able to change records without making a selection. Does the field that the control is bound to have a default value?

 

[Craig0201]

A check box can be assigned null if it has TripleState = True.

However, you could also try using NZ([YourField],0). This will return false when your value is null and the value when it is not null.

Craig