limit text not to start with

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

Guest

I am using Access 2000 & 2003, I have a problem with people entering wrong
data in a field in my database, so i am thinking of restricting the field not
to start with a particular character. like the field should not start with
"D". i think i should be able to do this table view. Can someone pls help me
here.

Thanks
Sara Sun
 
1. Open the table in design view.

2. Select the field.

3. In the lower pane, set the Validation Rule property to:
Not Like "D*"
 
Thanks Allen
it worked. I have tried 'like' commands in query - never tried it in
validation rule in table.

Sara
 
set theValidationRule property to:
Not Like "D*"
Click to expand...

It would do no harm to make it ANSI Query Mode neutral e.g.

Not Like "D*" AND Not Like "D%"

Left([FieldNameHere], 1) <> "D"

Jamie.

--
 
Back
Top