> Great question Rudy! I wondered the same thing and stumbled across this > function that is native to Access.
stumbled, how? it sure isn't in the access 2000 help file, is it "native to access" -- it is to laugh > (StrConv([text1],3)) - 3 stands for vbProperCase but Access > didn't like the verbiage so I let it be 3. that's it, right on the money > Let me know how this works for you! oh, i'd already found it, after a half hour on google one day last week i just thought it was a simple problem, and wanted to see if anybody else could find the answer without pulling their figgin hair out no fair looking in a vb reference, not everybody who uses access is a vb programmer think about that for a second not everybody who uses access is a vb programmer rudy ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]