Ucase Function

[BhujangaII]

This is a super remedial question, but it must be asked. I have been asked to make certain fields in a printable form appear in all caps, although the data itself is to be entered in another form in upper and lower case. I thought it would be as simple as using this:
=UCASE([field name])
for the control source. But it results in #Error in the field. What gives?
(I also tried UCASE$ with same result)
Thanks you.

 

[Remou]

If this is on a report, did you rename the control? That is, if the controls is called FieldName call it, say, txtFieldName.

http://lessthandot.com

 

[alvechurchdata]

Personally I try to avoid doing any processing within a report because it's so difficult to debug. I'd base the report on a query rather than on the raw table and make the query deliver all caps to the report.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[BhujangaII]

Thanks for both of your suggestions. Renaming the field did the trick so I went with that.