> 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]

Reply via email to