Validation rule

  • Thread starter Thread starter Sim
  • Start date Start date
S

Sim

How do i only allow certain letters to be entered on a
form. I want to only allowed letters A,C,D,I,L,N,S,T,V,W,
to be entered in the State text box on a form.
 
Sim said:
How do i only allow certain letters to be entered on a
form. I want to only allowed letters A,C,D,I,L,N,S,T,V,W,
to be entered in the State text box on a form.
Click to expand...


Or, if you want to allow more than a single character (e.g.
TVW) where all the characters must be in your list:

Not Like "*[!ACDILNSTVW]*"
 
Back
Top