Input mask/combo box/query problem

[mscertified]

I have a phone number column, data is stored as 9999999999 and displayed with
input mask (999) 999-9999. The data can be typed in or selected via a combo
box (as one column of many) and combo box uses a query that does not format
the phone number. When a record is selected, it displays fine. However in
the combo box selection column it is displayed unformatted. If the query
formats it, when I transfer the column to the control with the input mask,
the number is messed up as it tries to format it twice. How to get around
this so I have it formatted in the combo box column and in the resulting form
control?

Thanks.

 

[Evi]

Not sure from this what you've tried but you can format the combo itself
using the Properties box and typing in
(000)000-0000
next to where it says Format.
See if this gives the effect you want.
Evi

 

[mscertified]

In a multi-column combo box?

Not sure from this what you've tried but you can format the combo itself
using the Properties box and typing in
(000)000-0000
next to where it says Format.
See if this gives the effect you want.
Evi