IMO, don't allow data entry directly into tables. Always use forms for user
interaction.

--
Duane Hookom
Microsoft Access MVP


"WolfDog" wrote:

Dorian,
What if I am not using forms and entering data directly to table (or
importing data to table?)

"Dorian" wrote:

This is one of many ways to do it...
In your form's Before Update event, you code:
Me!Number = Right$("0000000000000" & Me!Number,13)
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"WolfDog" wrote:

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!