S
sargum
Hello,
I posted a week or so ago but have not had much luck.
I found the following from MS Access Help Menu (see below) and need a
workaround. It explains why I can't keep the input mask in my drop
down list but I still need a workaround.
-------------------
Input Mask:
Note Only characters that you type directly in a control or combo box
are affected by the input mask. Microsoft Access ignores any input
masks when you import data, run an action query, or enter characters in
a control by setting the control's Text property in Visual Basic or by
using the SetValue action in a macro.
-----------------------
This is my original post:
I am using Access 2002. I have a combobox in a form that allows one to
find a record in the form by selecting a value from a list.
The combox list is generated from a table called "Wafer Info". The
field is called "Wafer Name" and the format property is text. The
field in the table carries an input mask. It is
"NM-"00"W#"00"(CCF"000")" I put in the input max into the input mask
property of the combox box as well.
When I click on the drop down list, I just see a list of numbers
0000000 instead of NM00W00CCF000. However, when I click 0000000, it
changes the display in teh combo box to the correct label of
NM00W00CCF000, but only does so after I click it. This will be
confusing to my users. They need to see the list with the input mask
applied; they will not be able to easily deduce that 0000000 is
NM00W00CCF000.
Thank you for your help!
I posted a week or so ago but have not had much luck.
I found the following from MS Access Help Menu (see below) and need a
workaround. It explains why I can't keep the input mask in my drop
down list but I still need a workaround.
-------------------
Input Mask:
Note Only characters that you type directly in a control or combo box
are affected by the input mask. Microsoft Access ignores any input
masks when you import data, run an action query, or enter characters in
a control by setting the control's Text property in Visual Basic or by
using the SetValue action in a macro.
-----------------------
This is my original post:
I am using Access 2002. I have a combobox in a form that allows one to
find a record in the form by selecting a value from a list.
The combox list is generated from a table called "Wafer Info". The
field is called "Wafer Name" and the format property is text. The
field in the table carries an input mask. It is
"NM-"00"W#"00"(CCF"000")" I put in the input max into the input mask
property of the combox box as well.
When I click on the drop down list, I just see a list of numbers
0000000 instead of NM00W00CCF000. However, when I click 0000000, it
changes the display in teh combo box to the correct label of
NM00W00CCF000, but only does so after I click it. This will be
confusing to my users. They need to see the list with the input mask
applied; they will not be able to easily deduce that 0000000 is
NM00W00CCF000.
Thank you for your help!