Need to have a field always have 13 characters & insert leadin
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?)
|