>>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