Lower to Upper Case in Labels

[331]

Could someone provide me with the exact VBA code to use to change lower case to upper case for specific fields when printing REPORT labels --
sample field names: [LastName] [PermStreetAddress] [PermCityStateZip]

I've tried many variations of UCase([LastName]) and I get the error message that the LastName is not recognized. I'm familiar with VBA coding in a form, but not a report.

MANY thanks for whatever help you can provide.
331

 

[Rich]

=UCase([YourField] )

 

[Laurentech]

You need to put Me.Lastname=Ucase([Me.LastName]) in the Detail_Format event of your report.

Larry

 

[331]

THANKS to you all! I was incorrectly putting several lines of code in a sub routine -- Private Sub Report_Open(Cancel As Integer)
but I now put this in the actual control source field in DESIGN view!! =UCase([YourField])
Works great!
331