Solved PROPER function?

[catbeasy]

I'm using Access 97 and cannot find a PROPER function like in Excel. There appears to be only UCASE and LCASE functions.

Does anyone have any suggestions on what I can use for a Proper Function?

Thanks..

 

[pbaldy]

Look at the StrConv function in VBA help (I assume it was available in 97).

 

[boblarson]

(I assume it was available in 97).

I guess so:

http://support.microsoft.com/kb/302499

 

[catbeasy]

Ok, that works, thanks..