How to Format Text Fields in Access
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.
Free to distribute with our compliments; we hope you will consider our paid training.