Uppercase character limitation for textbox?

[ddub]

Hi,

I am having a problem uppercasing a bound textbox in my Access 2000 report. When I put a '>' in the format property for my textbox, it seems to uppercase the first 250 characters then cuts off the rest of the text. At first I thought that the CanGrow property of my textbox was set to No, but it wasn't. Then I tried taking off the '>' and all the text printed out just fine, except it wasn't in uppercase now.

Any ideas or workarounds? I haven't been able to find anything about this problem on Microsoft's site.

Thanks.

 

[CosmoKramer]

Try the UCase function. Add an unbound textbox to your report, and set the control source to the field you want to change case:

=UCase([Yourfield])

 

[ddub]

Thanks for the suggestion Cosmo, I didn't get to try it though because I did my own workaround. In the view that's the recordsource for my report, I created a field called UPPER(Description) that I aliased to ProjectDescription and then used this field in my report.

Your way with the unbound textbox looks like it should work too.

Thanks again,
ddub