input mask for field in combo box

[deekras]

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?

 

[pdx_man]

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

 

[deekras]

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

 

[deekras]

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?