Capitalise field in Report

[Baldeagle]

A field that I have inserted into a report is made up of a string of individual fields from my Donors table to make up a Name & Address. In the table 2 fields 'Town/City' and 'Postcode' are formatted with a '>' to display as Upper Case even if the data is entered in Lower Case. But I can't get my string in the report to display these two fields in Upper Case. My string is '=[Title] & " " & [Christian Names] & " " & [Surname] & " " & [Address 1] & " " & [Town/City] &" "& [Postcode]'. How can I force these last 2 fields to display in Upper Case in the report without displaying the whole string in Upper Case?

[RuralGuy]

Have you tried to use the UCase() function?

[Baldeagle]

Thanks for the advice. I had tried UCase but had omitted to include the brackets ().

[RuralGuy]

Glad we could help.