G
Guest
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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>
able to come up with anything.
Like "R[0-9][0-9][0-9][0-9][0-9][0-9][0-9]"
--
Ken Snell
<MS ACCESS MVP>
followed by any 7 number, such as R1234567. I am trying but haven't beenMike Etzkorn said:Is there any way to set the validation rule for a text box to be "R"
able to come up with anything.
K
Ken Snell
Or
Like "R#######"
--
Ken Snell
<MS ACCESS MVP>
able to come up with anything.
Like "R#######"
--
Ken Snell
<MS ACCESS MVP>
followed by any 7 number, such as R1234567. I am trying but haven't beenMike Etzkorn said:Is there any way to set the validation rule for a text box to be "R"
able to come up with anything.