>>>I have a character field named VAN that allows null values in my table. I want to create a Field Validation Rule that will allow the entry of "EW", "VC", or leave it empty. What is the correct syntax for this? When I try van=="EW".OR.van=="VC".OR.van=.NULL. it allows me to enter any value (i.e. "DD"). Any ideas?
>>>
>>>Thanks!
>>>
>>>Jeff
>>
>>Use either textbox with
>>.Format="M"
>>.Inputmask=",EW,VC"
>>or even better small combobox.
>>You can convert empty value into .NULL. in code before saving.
>
>Thanks for the reply Edward. But I'm trying to set the field validation rule so users won't be able to enter incorrect values from MS Query. I don't understand why van=="EW".OR.van=="VC".OR.van=.NULL. won't work. In another field I'm using drivcode="EMP".OR.drivcode="STU".OR.drivcode="VOL" and it works great. But if I change it to drivcode="EMP".OR.drivcode="STU".OR.drivcode="VOL".OR.drivcode=.null. it doesn't work -- it allows any characters to be entered.
>
>Is this a bug or what?
>
>Jeff

I don't know. Honestly, I don't use field-validation rules.