i would like to make a combo box with 2 columns. the first will be the comapny name the second the account number. i have the account number stored as a series of numbers, but i alway shave it displayed as 12-9008 with the input mask. however, when i try to use the input mask for the combo box, it doesn't display it that way. any suggestions?

In the underlying query behind the combo box, format the field the way you want it.

i tried that. the imput mask will not save no matter how many times i try.

when i click on underlying query behind the combo box, it is displayed correctly with the dash (-) ie:19-9008, but when i go to the combo box on the form it does not have the dash (-).

any suggestions?