Formatting Data in Combo Box

[Ian]

I have a Combo Box on a form using the Query Bilder to
create the Row Source. The 3rd column in my combo box
displays a phone number, which in the combo box is not
formatted at all, just 10 numbers straight. In the
associated table, and queries, including the query
builder, the phone numbers are formatted as set by the
linked table's properties. Is there any way I can format
the numbers in the combo box.

Thank you in anticipation
Ian

 

[Bas Cost Budde]

Base the combobox on a query that uses the format() function for the
phone field, something like AIR CODE format([phone_no],"(000)-000 000")

 

[James Goodman]

Take a look at the input mask property for the control, found on the Data
tab. However, I think this formatting will be lost once the control loses
the focus...

 

[Bas Cost Budde]

Will an input mask format some column in a combobox, other than the bound?

 

[Guest]

Thank you very much - it works. Fantastic!

Ian