Input mask for different values of look-up field

[TylerTand]

I have a look-up box for other numbers. I have manually typed the list as it is only 4 different possibilities. But each possibility needs a unique input mask to ensure proper inclusion to the record. Is it possible to have separate input masks for each of the 4 options in the drop down box. Thanks for your comments.

 

[TylerTand]

Bump. Can anybody help me please?

 

[WayneRyan]

TT,

You can add another column to the table that stores your combo box
selections ... the input mask.

Then, use the AfterUpdate event of the ComboBox to set the input masks
with something like:

Me.SomeOtherField.InputMask = Me.ComboBox.Column(2)

hth,
Wayne