Problem With ComboBox

[ACCESS]

access2002, sql server 2000
I have a combo box in which the data is entered with input mask . when I
click for showing list of items they appear without any mask. How can I do
to make this combo box show list of items in the form of input mask?

Thanks in advance,
Reza

 

[Douglas J. Steele]

Input masks are just that: masks used for inputting data. They don't usually
affect the way that the data's stored in the tables.

Try creating a Format statement that displays your data how you want it, and
base your combobox on that, not on the table.