Listbox

[Guest]

I have a listbox that is populated by a query. The columns in the query are
formatted in the query themselves. The phone number has an input mask of
\(999") "999\-9999" x"999999

using this input mask, when the query runs in the query builder the
telephone number is displayed proprely, that is, (123) 456-7890 x123456.

the problem is when the listbox is displayed, the formatting is removed and
1234567890123456 is displayed. What am I missing?

thanks in advance for your help!

 

[Douglas J. Steele]

Create a query that uses the Format function to format your phone number.

Use the query as the row source for your listbox.