Validation rule begining with a number

[Cathy]

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!

 

[KARL DEWEY]

Check the datatype of the field. It needs to be text.

 

[Cathy]

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

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

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!