Forum home » Delegate support and help forum » Microsoft Access Training and help » Tables
Sara has attended:
Access Introduction course
Access Intermediate course
i'm inputing data into the table into field I named telephone number why isnot the zero showing ?
Hi Sara,
Thank you for your post;
Access like Excel does not recognise leading zeros (0) so in order to display the zero you must create your table using a text field for the telephone number.
regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
To insert the current date into a Table field or Form Text box use:
Ctrl+Semi-Colon(;)
TrustScore
4.9
/ 5
2431 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street,
Limehouse Basin, London, E14 8BT, United Kingdom.
