How to allow only two types of entries???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am working with a form where I have one field
that needs to be restricted to accept only one of two
entry types. Either T-TE#### or ####T###, I am probably
overlooking something simple here, but I've tried various
things with validation and input masks but no luck so far.

TIA
 
Hello, I am working with a form where I have one field
that needs to be restricted to accept only one of two
entry types. Either T-TE#### or ####T###, I am probably
overlooking something simple here, but I've tried various
things with validation and input masks but no luck so far.

TIA
Click to expand...

How about
(left(fieldname,4)="T-TE" OR mid(fieldname,5,1)="T")
?
 
no such luck :(
Click to expand...

Hi. How come? I meant this as a validation rule, but I see I forgot to
mention that.

Did you try it? And to what result? Error? Silent acceptation?
 
Back
Top