Form validation rules

[sesling]

I have a form that has several text boxes where the operator can enter data. I want to place some validation rules around what the operator can enter.

In one box I want the number to be at least 3 digits (001 - 999). Every time I put in a number with leading zeros in the validation rule they get stripped off and the system will accept a single number. I tried ??0 and 000, like 000, like ???. Is there a validation rule will require 3 digit number and accept leading zeros?

In another box I have the operator entering dates. Is there any validation rule that will ensure the date entered is a valid date?

[Rabbit]

You have to make the field text to have leading zeroes.

If the field is Date/Time then you don't need a validation rule. They can't enter anything that's not a date.

[sesling]

You have to make the field text to have leading zeroes.

If the field is Date/Time then you don't need a validation rule. They can't enter anything that's not a date.

Not sure how to do the first one "make the field text to have leading zeroes". how and where would this be entered?

On the Date/time, how would you require the date be in a yyyymmdd format? That date format is not one of the selections for date/time.

[Rabbit]

Not sure how to do the first one "make the field text to have leading zeroes". how and where would this be entered?

On the Date/time, how would you require the date be in a yyyymmdd format? That date format is not one of the selections for date/time.

If you go into design view for the table and select the field and change the data type to text.

Why do you need date in that format?

[sesling]

If you go into design view for the table and select the field and change the data type to text.

Why do you need date in that format?

On the first item, I am not entering the data into a table but passing it to a command button as criteria.

The date needs to be formated yyyymmdd when its passed as criteria to the program that will use it.

[Rabbit]

On the first item, I am not entering the data into a table but passing it to a command button as criteria.

The date needs to be formated yyyymmdd when its passed as criteria to the program that will use it.

You can either use AAA as the input mask or do it in the After Update event to append leading zeroes. Either way you may want to check that it's actually a number.

Why not format it as a date and then format it back to yyyymmdd when you pass it to the program?

[sesling]

You can either use AAA as the input mask or do it in the After Update event to append leading zeroes. Either way you may want to check that it's actually a number.

Why not format it as a date and then format it back to yyyymmdd when you pass it to the program?

On the first issue I placed an Input Mask of 000 and this works. It requires 3 digits and accepts leading zeros.

I was able to get my boss to accept the different date entry to a more standard one of mm/dd/yyyy. When I pass the value to the command line I format it to yyyymmdd. Thx for your help on this

[Rabbit]

Not a problem, good luck.