Don't know if you found a solution to your issue. The below little
routine returns a 13 character string with leading zeros and the
number set to the right.
HTH
--
-Larry-
--
"WolfDog" wrote in message
...
Jeff,
I need to actually store the value as 13 characters. 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.
"Jeff Boyce" wrote:
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!