Equivalent of LCase and UCase in queries

[ramonmiro]

Hi, I'm looking for the equivalent function of vbProperCase, than can be used in queries, like LCase and UCase.
I modules we can do it using InStr, Mid and , Right functions, but in queries this would be long

Thanks

 

[arnelgp]

can you use StrConv([theField], 3).
don't use vbProperCase (constant) use numeric equivalent
as in the above for Queries.

 

[jocph]

Confirmed working.