Depends on whether you want to STORE thirteen characters for each value or
DISPLAY thirteen characters.
If you need to store 13, consider using a Text data type for the field.
If you wish to display 13, and plan to "do math" on the values stored, use
numeric AND use a format as advised else-thread.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"WolfDog" wrote in message
news
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!