Input mask for ComboBox not working

[Tony_VBACoder]

Access 2000/2002:

Does anyone know how I can get the Input Mask to work properly on a Combo
Box?

I have a combo box that has a list of items (7 characters in length) where
all the items begin with the letters "75" followed by 5 characters. I would
like to have an Input Mask where "75" is the first thing in the combo box, so
that user does not have to always type "75" to begin looking for the item in
the combo box, since all items begin with "75".

My combo box has the "Limit To List" property is set to "Yes". However, if
I try and put an "Input Mask" equal to "75"CCCCC, my combo box does not
function properly.

For instance, if I have "75"CCCCC as the Input Mask, and an item I am trying
to find in the list is "7506030", and I begin typing "06030", my combo box
does not automatically find it. With this Input Mask set, I do notice that
if I start to type in the combo box, "75" does get pre-filled in because of
the mask. However, if instead of typing "06030", I type "7506030", my combo
box does find my item.

What am I doing wrong? What are the settings that I need in order to
accomplish? Is this possible?

 

[Terry]

I am not really up to speed on masks but I do know that you have an option of
returning either the bare value "06030" or the full value "7506030". Use the
mask builder to build the mask. It covers this nicely.
Additionally, if your combo has a hidden linked value you must set the value
of the combo to the hidden value
eg
cbo.RowSource="SELECT ID, Name FROM Members"
cbo.ColumnWidths="0cm;4cm"
if the ID is the bound column you must set the combo in VBA to the value of
the ID
HTH
Terry