Validate text box - 1 or null ONLY

[gcole]

How do I allow 1 or Null only in a text box bound to a table? I have 56 records to validate.

 

[mp9]

Use a Validation Rule on the underlying table field. The rule would be something like:

=1 Or Is Null

To set this rule, go into the underlying table's design view, select the relevant field and you'll see "Validation Rule" listed in the field properties.

 

[gcole]

Thank you. I used this in the properties section of the text box and it worked great. I was trying to put in = 0 Or null. It's the little things!