>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.
Edward Pikman
Independent Consultant