Formatting Issues

Display Access Text Fields in Uppercase on Forms and Reports

Olivia MillerOlivia Miller Nov 13, 2026 868 views

Question details

The user wants text fields to appear in uppercase consistently on Access forms and reports.

Display Access Text Fields in Uppercase on 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the object in Design View

In the Navigation Pane, right-click the form or report and select Design View.

2
Select the text box

Select the text box bound to the field, then open the Property Sheet from the Design tab if it is not already visible.

3
Set the display format

On the Property Sheet's Format tab, enter > in the Format property.

4
Repeat and verify

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.

Set the Format property on form and report controls
Display only: The > format changes how the text appears; it does not convert the value stored in the table.
Free Microsoft Office alternative

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.

Use a familiar interface for everyday document, spreadsheet, and presentation work.Open and edit compatible Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTX.Apply text formatting in WPS documents and spreadsheets.Use a free, lightweight suite for compatible Office files.
microsoft office alternative - wps office

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.