Convert part of a text using an expression in the control source field

[alollgm]

I've created a form in MS Access 2000. Now I'm attempting to format the input in a report.

In a text box, I have the following expression:

="Please have your son," & [Name] & " report to class on time."

I'm trying to have the name printed in upper case.

How can I do this?

 

[SkipVought]

Hi,

="Please have your son," & UCase([Name]) & " report to class on time."

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}