S
Sarah0824
Is there a way to make a phone input mask flow from right to left so I don't
have to type in a zip code?
have to type in a zip code?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry Whittle
Zip code? Area code!
I recommend not using input masks at all on phone numbers or zip codes. The
first time that you have to enter an address or phone number from somewhere
like Enlgand, you'll see why.
I recommend not using input masks at all on phone numbers or zip codes. The
first time that you have to enter an address or phone number from somewhere
like Enlgand, you'll see why.
S
Sarah0824
Sorry - I did mean area code...
I know it doesn't work well for places other than the US, but that won't be
a problem with this database.
I know it doesn't work well for places other than the US, but that won't be
a problem with this database.
D
Duane Hookom
I would follow Jerry's advice. Allow users to enter whatever they want and
use the after update event of the text box to add the finishing touches.
Private Sub txtPhone_AfterUpdate()
If Len(Me.txtPhone) < 9 Then
Me.txtPhone = "(715) " & Me.txtPhone
End If
End Sub
You could add more features to put in missing hyphens, check for numeric, or
other stuff.
use the after update event of the text box to add the finishing touches.
Private Sub txtPhone_AfterUpdate()
If Len(Me.txtPhone) < 9 Then
Me.txtPhone = "(715) " & Me.txtPhone
End If
End Sub
You could add more features to put in missing hyphens, check for numeric, or
other stuff.
S
Sarah0824
Thanks. That ought to do the trick. Appreciate the help!!