Capitalise first letter of Town

[glat]

I have a text box with the following:-

=Trim([Address Line 1] & (", "+[Address Line 2]) & (", "+[Address Line 3]) & (", "+[Address Line 4]) & (", "+[Town]) & (", "+[Property.Post Code]))

What I would like is for [Town] to be an initial capital and not all caps. Any help much appreciated.

[Seth Schrock]

Try something like this:

strName = StrConv(strName, VbStrConv.ProperCase)

[glat]

Where would I put this?

[Seth Schrock]

Try adding it to your current textbox like this:

=Trim([Address Line 1] & (", "+[Address Line 2]) & (", "+[Address Line 3]) & (", "+[Address Line 4]) & (", "+StrConv([Town], VbStrConv.ProperCase)) & (", "+[Property.Post Code])) 

[glat]

I've put this in but in the form proper is #Name?. I've noticed when I input the code ... (", "+StrConv([Town], VbStrConv.ProperCase)) changes to ... (", "+StrConv([Town],[VbStrConv].[ProperCase])) in the Control Source.

[Seth Schrock]

Is this a VB.NET application or an MS Access database?

[glat]

It is MS Access database.

[Seth Schrock]

For future reference, MS Access questions need to be asked in the Access forum. I have requested a moderator to move this to the correct forum, but in the meantime I will answer here.

Now that I know this isn't a VB.NET application, try this instead:

=Trim([Address Line 1] & (", "+[Address Line 2]) & (", "+[Address Line 3]) & (", "+[Address Line 4]) & (", "+StrConv([Town], 3)) & (", "+[Property.Post Code])) 

[glat]

My apologies, I did not realise I was posting on a VB forum. It works perfectly. Thank you.