Text Box Validation

M

Mike Etzkorn

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.
 
K

Ken Snell

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 said:
Is there any way to set the validation rule for a text box to be "R"
Click to expand...
followed by any 7 number, such as R1234567. I am trying but haven't been
able to come up with anything.
 
K

Ken Snell

Or

Like "R#######"


--
Ken Snell
<MS ACCESS MVP>

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Validation Rules for a Control on a Form (?) 4
Wrapping and Anchors 0
OLE Word spelling 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Link a text box based on drop down box with four options MS Word 365 0
Absolute position in Layout 2
Outlook mail shared questions 0

Top