G Guest May 26, 2004 #1 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.
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 May 26, 2004 #2 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.
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 May 26, 2004 #3 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.
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.
