Capitals in Report

[teebird]

Hi

I want the records printed in my report to be in capitals.

I have put format to capitals code in my form but it still displays the records in my report as how the user entered them...some small some caps.

Any suggestions...

 

[teebird]

Worked it out myself - thought I would post this - may help others.

This will format the records to capitals in a report and remove unwanted spaces and place a , and a couple of spaces between LName and FName

=Format([LName],">&quot & ", " & Format([FName],">&quot