By Richard Rost 4 months ago
Display Leading Zeros on a Number in Access
In this Microsoft Access beginner tutorial I'm going to teach you how to keep the leading zeros in front of a number such as a ZIP code, social security number, or any other type of data.
Mia from Annapolis, Maryland (a Gold member) asks: I'm new to Microsoft Access and I have ZIP codes from some of my customers that start with zero. Whenever I display them on a mailing label I'm only seeing four digits. I know in Excel you can type a single quote to keep that leading zero. How do I do this in Access?
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, leading zeros, leading zeroes, zeros at front of number
Subscribe to Leading Zeros
Get notifications when this page is updated