Validation rule begining with a number

C

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!
 
C

Cathy

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!
 

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

Top