>>>>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.
Hey Jeff, have you tried ISNULL()?
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...