Formatting Data in Combo Box

  • Thread starter Thread starter Ian
  • Start date Start date
I

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
 
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")
 
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...
 
Back
Top