Street Address Imput Mask

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)

M Landon said:
I'm am trying to set up an imput mask for the street address feild in my
Click to expand...
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.
 
M Landon said:
I'm am trying to set up an imput mask for the street address feild in my
Click to expand...
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
 
Back
Top