Reports and Proper case 1

[belovedcej]

So I know this is all over the web as well as this forum - but I'm adding to the mess.

I referred to this thread and followed instructions accordingly:

http://www.tek-tips.com/viewthread.cfm?qid=1245067

The problem is, although I don't get an error, my field is completely blank!

Based on many different answers here and the web, I have tried all of these
=strConv(field, vbProperCase)
--no error, but shows blank
=strConv(field, 3)
--no error, but shows blank
=Propercase(field)
--function not recognized and treated as parameter.
=Proper(field)
--function not recognized and treated as paameter.

I do recall something about setting the format property value to > or < to switch to upper, lower case instead of using a function, but I can't find it documented anywhere - I just know it works. Is there something like maybe = that would work for proper case?

 

[Remou]

Have you changed the name of the textbox control to something other than the name of the field?

 

[belovedcej]

yes. the name of the textbox control is txtCaption, the name of the field is Caption

 

[Remou]

=strConv(field, 3)

Works for me. It seems likely that Caption is causing the problem. Can you rename the field in a query, or in the table?

 

[belovedcej]

that did it! have a star. I've never had issues with it before, but it must be a reserved word or something. Thanks again!