Validation rule begining with a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a validation rule on a table/field where the field must begin
with a number, but then can be any length and any mixture of numbers and
characters. I've tried: Like "[0-9]*" Or Is Null

But it is not working; it will not accept characters. It will only accept
numbers of any length.

What else can I try?

Thank you!
 
Thank you so much! Something so obvious, but I wasn't catching it.



KARL DEWEY said:
Check the datatype of the field. It needs to be text.
--
KARL DEWEY
Build a little - Test a little


Cathy said:
I need to write a validation rule on a table/field where the field must begin
with a number, but then can be any length and any mixture of numbers and
characters. I've tried: Like "[0-9]*" Or Is Null

But it is not working; it will not accept characters. It will only accept
numbers of any length.

What else can I try?

Thank you!
Click to expand...
Click to expand...
 
Back
Top