Input mask/combo box/query problem

  • Thread starter Thread starter mscertified
  • Start date Start date
M

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.
 
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
 
In a multi-column combo box?

Evi said:
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
Click to expand...
 
Back
Top