Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Input Masks

Status
Not open for further replies.
vepz

vepz

Technical User
Joined
May 3, 2005
Messages
30
Location
US
Can one field on a form cause the input mask in a second field to change based on the value in the first field?

Thanks,

Greg
 
Sort by date Sort by votes

I've never had a need for this, but how about something like this...
Code: 
Select Case Me.txtFirstField
    Case [i]CriteriaA[/i]:
        Me.txtSecondField.InputMask = [i]InputMaskA[/i]
    Case [i]CriteriaB[/i]:
        Me.txtSecondField.InputMask = [i]InputMaskB[/i]
    Case Else:
        Me.txtSecondField.InputMask = [i]Default[/i]
End Select

Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Create multiple reports
2 3
Replies
47
Views
3K
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question Question
Running query with parameter from Inputbox
Replies
8
Views
1K
TrekBiker
TrekBiker
meagain
  • Locked
  • Question Question
DLookup with Multiple Criteria
Replies
3
Views
508
Andrzejek
Andrzejek
jnuus
  • Locked
  • Question Question
MsgBox/InputBox Titlebars = integers?
Replies
8
Views
550
jnuus
jnuus
misuser2k7
  • Locked
  • Question Question
Wild card search on combo box with multiple rowsources
Replies
1
Views
243
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top