Leading zeros in an Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I display leading zeros in an Access database, e.g 012345 ? The field
is IDNumber and the data type is 'number'. Thanks
 
A number can't have leading zeros. You'd need to change the field to text.

--
Patricia Cardoza
Outlook MVP
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003

http://blogs.officezealot.com/cardoza

"Leading zeros in Access database" <Leading zeros in Access
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top