Hi!
I have a SQL table INT field that is being used as the control source for an editable Text Box in an Access application. I have the following validation rule applied to the text box:
In ("1","2",=Null)
However, the portion where I try to equate the Text box to Null doesn't work. I have also tried the empty string (=""). 1 and 2 will update the associated SQL table with the appropriate value, and any other number will not be allowed (the box will only take 1 & 2). I want it to be able to take a blank space and equate the SQL table to NULL . I have checked and the SQL table will allow NULL for that field.
Does anyone have any advice?