The intent is to allow the user to input their internal "item #" and have it
automatically add leading zeroes and store that value as a 13 character
string. The end user of the value requires a 13 digit number. No math will
be done...reference only. The automatic part part is where I am having
trouble.

"Clifford Bass" wrote:

Hi,

Try setting the Validation Rule property for the column to:

Like "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]"

And so as to make it kinder to the user set the Validation Text
property to something like:

Please enter a 13-digit number.

Clifford Bass

"WolfDog" wrote:

Dorian,
What if I am not using forms and entering data directly to table (or
importing data to table?)