Only allow certain numbers in textbox

[templeowls]

I have a textbox bound to a number field in a form. I only want the user to be able to put '1', '2' or '3' in the textbox.



Ideally, if the user put any other number in the field, it'd clear it out and populate a msg box.

Any suggestions on how to code that besides switching it to a combobox?

[Bob Fitz]

You could use the following code in the BeforeUpdate event of the textbox:

    If Me.ActiveControl <> 1 And Me.ActiveControl <> 2 And Me.ActiveControl And 3 Then        
        MsgBox Me.ActiveControl & " is an invalid number", , "INVALID NUMBER"
        Cancel = True
        Me.Undo
    End If

[templeowls]

Nvm. Solved with validation rule

[Bob Fitz]

...Ideally, if the user put any other number in the field, it'd clear it out and populate a msg box....

I thought that meant that you wanted the invalid number removed. I don't believe that a validation rule will do that.

[ArviLaanemets]

Why not simply to use a combo box instead?

[Missinglinq]

Or an Option Group?

It's almost always better, and saves the user's time, to prevent wrong data from being entered, rather than fixing it after it's been incorrectly entered.

If space on your Form is limited, you can always arrange an Option Group with the choices available in a straight line, rather than the default 'up-and- down,' configuration...taking up no more space than a Combobox would.

Linq ;0)>