Interactive Tutorial
How to Format Text Fields in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can change how a text field displays its information by modifying its number property. Unfortunately, unlike number fields, text fields donβt have any ready-made settings and must be formatted manually.
The Format property only changes how data is displayed on screen, not how the data is actually stored in the field.