Title Case Validation

J

Joey041

Hello,

I know how to make a validation for lower case and upper case but I can't
seem to find one that requires a title case. Is there one?
 
A

Arvin Meyer

Joey041 said:
Hello,

I know how to make a validation for lower case and upper case but I can't
seem to find one that requires a title case. Is there one?
Click to expand...

There is no Validation but you can use the AfterUpdate event to change the
text to TitleCase (aircode):

Sub txtMyControl_AfterUpdate()
Me.txtMyControl = StrConv(Me.txtMyControl, vbProperCase)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top