StrConv Function

[fredk]

Hi - I have a backend database that I use Access on the front end. One of the fields has all capital letters - I need to convert these to proper case so I can use in a letter to clients.

I was trying to use the StrConv Function - A few questions - First, can I use this on the linked field or do I create a second field?

What is the syntax for StrConv? I am having a problem figuring it out. ???

Thnaks for the help!!!

 

[THoey]

Since you are using this in a report, it should be something like:

StrConv([FieldToConvert], vbProperCase)

This should work for linked fields, as it is not changing the distant end data, just modifying how this data gets displayed... Terry M. Hoey

 

[jebry]

Hi!

You should be able to do it on the linked field, but if you plan to store the converted info for later use, you may want to put it in a different field so you will not change the original database. The syntax for StrConv:

StrConv(YourString(field), vbProperCase(or other conversion))

hth
Jeff Bridgham
bridgham@purdue.edu

 

[fredk]

Thanks TH3856 and Jebry for your quick responses - I appreciate your help!!!!!!!

Fred

 

[fredk]

I'm sorry, I have one other question - Where would I insert the function? I tried to set it up in the current event of the form and I am getting a compile error: "Expected: ="

What am I doing wrong? I tried to create a seperate field and use the data source as StrConv([company], vbProperCase) and it did not work -

I guess I am having problems understanding where I place the function?

Thanks much!!!

 

[fredk]

I got it - the following worked:

=StrConv([Forms]![frmApprovalLetter]![company],"3&quot

Thanks for all the help!!!

 

[jebry]

Hi!

If you are using the function as a control source in a textbox on a report or form, you will need to precede it with an =:

=StrConv(etc.)

hth
Jeff Bridgham
bridgham@purdue.edu