Display Access Text Fields in Uppercase on Forms and Reports
Question details
The user wants text fields to appear in uppercase consistently on Access forms and reports.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A text field has the greater-than Format property set at the table level, and the user wants forms and reports to display its value in uppercase.
- Observed behavior
- The table-level format does not automatically make the text appear uppercase in the relevant form and report controls.
Identify the text box controls on each form and report that need uppercase display. Decide whether uppercase is needed only for display or must also be saved in the underlying field.
Set the Format property on form and report controls
Use this method to display text in uppercase without changing the stored value.
Form and report controls can have their own formatting, so a table field's Format setting may not determine how an existing control displays its value.
In the Navigation Pane, right-click the form or report and select Design View.
Select the text box bound to the field, then open the Property Sheet from the Design tab if it is not already visible.
On the Property Sheet's Format tab, enter > in the Format property.
Apply the same Format setting to each relevant text box on your forms and reports. Save the objects and open them in Form View or Report View to check the display.

Save uppercase values with a form's Before Update event
Use a form event when text entered through that form must be stored in uppercase.
Work with Office documents using WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with compatible Office documents and moving everyday document workflows between suites. It does not replace Microsoft Access or change Access form and report formatting.

Frequently Asked Questions
Why doesn't the table field's uppercase format appear on my form?
An existing form text box can have its own Format property. Open the form in Design View, select the text box, and set Format to > in its Property Sheet.
Does the greater-than format save text in uppercase?
No. Setting Format to > changes the displayed text, not the stored value. To save uppercase text entered through a form, use UCase in the form's Before Update event.
How do I make text uppercase on an Access report?
Open the report in Design View, select each relevant text box, and enter > in the Format property on the Property Sheet. Save and open the report to verify the display.
Will a form's Before Update procedure convert all existing table records?
No. The procedure runs when a record is saved through that form. It does not automatically update existing records or entries made through other objects.




