input mask

W

wayne

Using MS Access 97

What is the input mask for the following "proper" text.:-

"Capital Letter For Each New Word"

???

Thanks in advance

Wayne
 
J

John Vinson

Using MS Access 97

What is the input mask for the following "proper" text.:-

"Capital Letter For Each New Word"

???
Click to expand...

There is none, input masks are not capable of this feat.

Instead either a) use a Form with VBA code in the textbox's
AfterUpdate event:

Private Sub textboxname_AfterUpdate()
Me!textboxname = StrConv(Me!textboxname, vbProperCase)
End Sub

or b) teach your users to use the Shift key. Proper names are a common
target for this kind of request, and results in people named Macauley,
MaCauley, McDonald, de la Cruz, von Gassenaur and e. e. cummings
getting very annoyed at their names being miswritten.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top