View Single Post
  #4  
Old September 21st, 2009, 07:59 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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?)