Table Definition that AutoPads with Spaces

whdyck

Registered User.
Local time
Yesterday, 23:21
Joined
Aug 8, 2011
Messages
169
I'm using Access 2003.

Is there any way to define a table text column so that, if data is entered that does not fill all the allotted space, the table will automatically pad that field to the right with zeros? Or does that need to be done when the column is actually populated?

Thanks.

Wayne
 
If you mean you want a number of leading zeros to be added, then say your field is five digits wide simply use 00000 as your Format.
 

Users who are viewing this thread

Back
Top Bottom