A dropdown list with two pre-defined InputMasks property

[Pada]

I have a data entry field, [Student No.], with two pre-defined formats with input masks as following.

AB-999\-9999\-9999;0 and
CD-999\-999999999;0


In the table's field property, there is only one Input Mask property, but I need to have two different input masks as showed above.



How can I create a dropdown list for the [Student No.] field that allows users to select either one of these two values on the list above.

Thank you very much in advance for your help.

[June7]

Have another control where student selects type AB or type CD. Then code changes InputMask property of combobox.

[Pada]

Thanks, June7 for the idea. Do you mean I should create a new combo box dropdown for two values, AB and CD, next to the StudentNo. for user selection? When user select either AD or CD, programming will capture the selected value and add the corresponding pre-defined inputmask property?

If you post sample of codes for these combo boxes, I would appreciate it.

Thank you!

[Welshgasman]

Simple If statement and set mask.
https://learn.microsoft.com/en-us/of...tbox.inputmask

Could possibly do it on the OnChange event of the textbox?

[Pada]

Sorry, I forgot to post that based on the 1st two characters, AD or CD to set the input masks as showed. Looks like June7 knows that even I didn't say that. I am trying to figure should I add another combo box so that when user clicks and select one of them and programming the input mask correspondingly.

[June7]

Could use a combobox or an option group with radio buttons or checkboxes or toggle buttons.

Regardless, code would be a simple If Then Else structure.

Is prefix AB or AD?

[Welshgasman]

Could also test for first character entered and then set the mask perhaps?

[June7]

Welsh, what event would you suggest? The Change event will trigger with each keystroke in box.

[Pada]

June7, sorry again for typo. It is AB. Thank you for your idea. I will work in that.

[Pada]

Welsh, I think I will use form Current event. With this event, the form will show the current values of AB and CD and will show the pre-defined input masks.

[moke123]

How about something in the keypress event?

(untested)

Private Sub Text5_KeyPress(KeyAscii As Integer)
 
    If Len(Me.Text5.Text) > 1 Then Exit Sub

    Select Case KeyAscii

        Case 65, 97
            Me.Text5.InputMask = "AB-999\-9999\-9999;0"
        Case 67, 99
            Me.Text5.InputMask = "CD-999\-999999999;0"
        Case Else
            MsgBox "Must start with A or C"
            Me.Text5.InputMask = ""
            KeyAscii = 0
    End Select
    
    Me.Text5.Requery

End Sub

You'll need to tweak it a lot to deal with various scenarios but it may be the correct event.

[Welshgasman]

Welsh, what event would you suggest? The Change event will trigger with each keystroke in box.

Yes, I am aware but the field length is small. Just offering another method? Could even test for length and ignore code after the first keystroke?

[Pada]

Moke123, thanks for the idea and the codes. I will take notes.

[Welshgasman]

Welsh, I think I will use form Current event. With this event, the form will show the current values of AB and CD and will show the pre-defined input masks.

Not when you are keying it in though, surely. Might need both two events in that case,

[June7]

Wait a minute. Combobox has no problem listing data in both structures. Is this combobox used for selecting only existing values or does combobox allow input of values not in list?