Title Case Validation

[Guest]

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?

 

[Arvin Meyer]

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?

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