View Single Post
  #1  
Old September 21st, 2009, 06:14 PM posted to microsoft.public.access.tablesdbdesign
WolfDog
external usenet poster
 
Posts: 4
Default Need to have a field always have 13 characters & insert leading ze

I need to create a table that includes a field that has to have 13 characters
(numbers) in it. If the user only enters 9 digits (or 11), it needs to
insert leading zeroes to make the value 13 characters. The value has to
include all 13 characters so it can't just be a display thing. The value has
to actually be 13 characters long.

Thanks!