How can I show related table value as uppercase MS Access report?

[TaylorTravels]

In my MS Access report, I want to display data from a related table in all caps. What is the simplest way to show related table value as uppercase MS Access report without changing the underlying table?

 

[WalterWah]

@TaylorTravels, you can use the upper() function in ms access to display related table values as uppercase in your report.

 

[charliedavid]

@TaylorTravels, the upper() function in ms access should work, also consider using the format function for more control over the output.

 

[HeatherMun]

@TaylorTravels, in ms access, the expression builder can also help customize your report's related table values as uppercase using the upper() function, just like others mentioned earlier.

 

[AngieMacal]

in ms access, you can also use the format function with the upper() function for more customized output, like format$(upper([related table field])), which gives more control over the display.

 

[Herman]

you can also use the strconv function in ms access for case conversion, offering more flexibility with uppercase conversions.

 

[Dwayne]

you can also use the propercase function in conjunction with upper for a cleaner report output.

 

[megamind]

i've found using the upper() function in ms access reports can be pretty handy for displaying related table values in uppercase.

 

[sarahmartin]

recently, the strconv function has gained attention for its flexibility in case conversions, including uppercase, in ms access reports.

 

[Gdeathswebscar]

you can also use the ucase function in ms access for simple uppercase conversions, it's a built-in function that works well with related table values.

 

[lindamary]

recently, ms access 2026 update includes improved support for uppercase functions, making it easier to customize report outputs.

 

[Kim Kardashian]

the latest ms access update in 2026 includes enhanced features for report customization, such as improved uppercase functions for related table values, giving users more flexibility in report design.

 

[miaharper]

i've also found that using the upper() function in ms access reports is quite useful, you can simply type =upper([field name]) in the report's text box to display related table values in uppercase.