StrConv

[shall]

Ok I am still learning some of the features of Access but where would I place this if I wanted to do Proper Case on a Form for controls called txtFName & txtLName? I understand that I need to change yoursting.

StrConv([yourstring], vbProperCase)

 

[ChipperT]

StrConv(txtFName.Value + " " + txtLName.Value,vbPropercase)

 

[Banana]

You mean as this:

StrConv(Me.txtFname & " " & Me.txtLName, vbProperCase)

?

 

[boblarson]

And if you are doing this in a control source or query you need to use 3 instead of vbProperCase.

 

[shall]

Ok now would I be placing that in the Events with On Lost Focus? And if so is that under expression builder? Sorry I just have some basic knowledge of Access and looking to learn more.

 

[Banana]

I'm sorry but I think we need more context because I now see that my reply may not have been that applicable if we're talking about two separate textboxes...

Can you explain more about the process, and how your form is set up and what you expect to happen? That way we can offer better answers instead of guessing in dark.

 

[shall]

ok i am looking to get a uniform look to first name and last name fields it is for 2 fields and i have been reading the other posts in regards to it but am getting a little confused as to where the coding goes. I have tried the code in expression builder and its not working and not sure if i would need to list more code for the code builder. Hope that explains it a little better

 

[shall]

Ok I got it to work Thanks for your help