limit text not to start with

[Sara Sun]

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

 

[Allen Browne]

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*"

 

[Sara Sun]

Thanks Allen
it worked. I have tried 'like' commands in query - never tried it in
validation rule in table.

Sara