Formatting a date in a multi column combo box

[Phyllis622]

I have combo boxes that contain attorney names and phone numbers. The attorney name is what is filled into the field when a selection is made from the combo box into the form. The phone number is just there for the occasions that the person managing the data in the database needs to call that attorney. Just a quicker way instead of having to go to another form to find the phone number. I created a query to combine the first and last name to one field (FullName) and this is where the combo box gets it's info.



When I run the query, the phone number is shown formatted as I want it to ((###)###-####), but in the combo box in the form, the phone number has no format to it. Any ideas what I need to do to get the phone number to show up formatted in the combo box list?

Thanks,
Phyllis

[ranman256]

in the query that the combo uses,
select [Attny], Phone#: format([phone],"(###)###-####") 'remember you cant label the field that already exists.

[Phyllis622]

Of course! I forgot. Working fine now...Thank you!