Use a validation rule such as this:

Like "R[0-9][0-9][0-9][0-9][0-9][0-9][0-9]"


--
Ken Snell
MS ACCESS MVP

"Mike Etzkorn" wrote in message
...
Is there any way to set the validation rule for a text box to be "R"
followed by any 7 number, such as R1234567. I am trying but haven't been
able to come up with anything.