Validating a Field

  • Thread starter Thread starter Frank O'Neil via AccessMonster.com
  • Start date Start date
F

Frank O'Neil via AccessMonster.com

I am having a problem validating a field, whenever the user enter it. I
have a field define as a text in my form, but I want this field to contain
both number and text and not be more 9 digit in length. The field must
start with an Alpha such as T12525265. I don't want it to be less than the
required field length whenever the users enter it such as T125252. I want
it to display message to the users, whenever this field is < 9 digits. I
try using a substring to eleminate the first letter when the user enter the
field,but did work, so that it can only validate the number. I need your
advise, or any help is welcome.
 
You might try using an Input Mask.

HTH,
Debbie

|I am having a problem validating a field, whenever the user enter it. I
| have a field define as a text in my form, but I want this field to contain
| both number and text and not be more 9 digit in length. The field must
| start with an Alpha such as T12525265. I don't want it to be less than the
| required field length whenever the users enter it such as T125252. I want
| it to display message to the users, whenever this field is < 9 digits. I
| try using a substring to eleminate the first letter when the user enter the
| field,but did work, so that it can only validate the number. I need your
| advise, or any help is welcome.
|
| --
|
 
Yes, I Used Input mask such as L99999999, when the user enter a field <
than the number, it does not activiate the message. The entry field must be
9 in lenghth and not less.
 
9 = Digit or space (entry not required)

Try L00000000

Debbie

| Yes, I Used Input mask such as L99999999, when the user enter a field <
| than the number, it does not activiate the message. The entry field must be
| 9 in lenghth and not less.
|
| --
|
 
Hi Frank,

To set the maximum length, define the field as Text, 9 characters long.

To ensure that the first character is a letter, use the validation rule
Like "[A-Z]*"

I don't understand whether evey entry must be 9 characters long or
whether you just want to warn the user if it's shorter. To enforce 9
characters, use a validation rule like this:

Like "[A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z]"

or for up to 9 characters, starting with a letter and inclding only
digits and letters, use

Like "[A-Z]*" And Not Like "*[!0-9A-Z]*"
 
Back
Top