#Error? message when using function

[EPD Hater]

I'm trying to use the UCase() function to change my text field on my report to all upper case. The text field has both letters and numbers (such as ph13301). On the report, I want it to display as PH13301. But when I employ the UCase() or UCase$() function, #Error? is printed instead of the value. What could be the problem?

Thanks,
Nick

 

[Fizzio]

Post the exact code you are using.

 

[Rich]

Did you set the control source to =UCase([YourField])

 

[EPD Hater]

Thanks Pat, it worked! I would not have figured it out myself.