Validation Rules

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

Guest

Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J
 
For the ID rule, try

[0-9INUT]####

For the date field, don't try to impose a format in the validation rule.
Instead, format the field or textbox the way you want, e.g.

dd-mmm-yy



Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J
Click to expand...
 
Thank you.

John Nurick said:
For the ID rule, try

[0-9INUT]####

For the date field, don't try to impose a format in the validation rule.
Instead, format the field or textbox the way you want, e.g.

dd-mmm-yy



Hello:
Can someone please help me with Table validation rules? I have an ID field
that stores text values(5 chars). The first character can be a number between
0 and 9 or one of the following letters: I, N, U, T, and the next four
characters are numbers. For example, N1234 and 50009.

I have tried [#INUT]#### but that does not work.

Also how can I write a validation rule for a date format like 01-Mar-01. I
want to use my own error message instead of the systems but I think I need to
create the validation rule first before the system will display the
validation message I create.
Thanks,
J
Click to expand...
Click to expand...
 
Back
Top