Title Case ??

[steve]

I want to make a form convert the text to
This Is A Sentance eg every first letter is capital.

I Put the following in the format line of the properties. >L<LLLL
I read this on some web sites.

When I put it in it turns it into ><\L"LLLL" and then simply seems to
put LLLLL at the begginning of the string and capitalizes nothing.
Can anyone tell me what Im doing wrong.

thanks

 

[StrayBullet via AccessMonster.com]

I've used:
Private Sub ControlName_AfterUpdate()
Me!ControlName = StrConv(Me!ControlName, vbProperCase)
End Sub

 

[steve]

I've used:
Private Sub ControlName_AfterUpdate()
Me!ControlName = StrConv(Me!ControlName, vbProperCase)
End Sub

Thank you for this. I may go your route, however I just wanted to use
the Access Gui and add a few characters rather than having to add code
for something so simple.

Regards
stive

 

[John W. Vinson]

Thank you for this. I may go your route, however I just wanted to use
the Access Gui and add a few characters rather than having to add code
for something so simple.

It's not that simple... <g>

Input Masks are not capable of doing the job. You can do it with code as
suggested, or with an Update Query updating the field to

StrConv([fieldname], 3)

where 3 is the vbProperCase constant's value.

John W. Vinson [MVP]

 

[steve]

Thanks. I have gone through and added the code to each field.

Regards