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 SkipVought 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
May 3, 2005
30
0
0
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
Create multiple reports 1
2 3
Replies
47
Views
216
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
155
TrekBiker
TrekBiker
meagain
  • Locked
  • Question
DLookup with Multiple Criteria 1
Replies
3
Views
74
Andrzejek
Andrzejek
jnuus
  • Locked
  • Question
MsgBox/InputBox Titlebars = integers? 3
Replies
8
Views
74
jnuus
jnuus
misuser2k7
  • Locked
  • Question
Wild card search on combo box with multiple rowsources
Replies
1
Views
38
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top