Formatting...

[srideout2525]

I have query. In the query that is based ononly one table, I have a phone number and fax number. All I am doing with the query is letting the results show in a list box on a form. I want the numbers to format as follows:

!\(999") "000\-0000;;_

So in the table I have it formatted that way, but it's not displaying on the form in the list box....


any help

(shoud I post this in the form section???)

 

[CJBIRKIN]

Hi

Try using the format option in the query that supplies the list box, Right Click on the field and select properties.

Hope that helps

Chris