Street Address Imput Mask

[M Landon]

I'm am trying to set up an imput mask for the street address feild in my project. I would like the names of the street to capitalize without hitting the shift button. ie: From 1200 long pond rd to this 1200 Long Pond Rd or 55 maiden lane to 55 Maiden Lane. Is this possible?? Any help would be appreciated

Thank You!

 

[Scott McDaniel]

You don't really need an input mask. Put this code in the AfterUpdate or
Exit event of your textbox:

Me.YourControl = StrConv(Me.YourControl.Text,vbProperCase)

I'm am trying to set up an imput mask for the street address feild in my

project. I would like the names of the street to capitalize without hitting
the shift button. ie: From 1200 long pond rd to this 1200 Long Pond Rd or 55
maiden lane to 55 Maiden Lane. Is this possible?? Any help would be
appreciated.

 

[Arvin Meyer]

I'm am trying to set up an imput mask for the street address feild in my

project. I would like the names of the street to capitalize without hitting
the shift button. ie: From 1200 long pond rd to this 1200 Long Pond Rd or 55
maiden lane to 55 Maiden Lane. Is this possible?? Any help would be
appreciated.

Try this line of code in the AfterUpdate event of the textbox holding the
Address field:

Sub MyTextBox_AfterUpdate()
MyTexBox = StrConv([MyTexBox ],3)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access