format list box

[smiley0q0]

is there any way to format a list box?

i have a list box that pulls data from my TblMain, everything works great except for the "OfficePhone" column... it pulls the number in just fine, but i have this input mask \(###&quot "###" - "#### in my table, the list box is just showing the numbers, i'd like it to show the numbers in the input mask format.

is that possible?

Thanks,
Smiley

 

[docmeizie]

It is possible. On the table when you created the phone number field did you create it using the format wizard?? If so you may want to go back and put this in:

!\(999&quot "000\-0000;0;" "

This is how my input mask is set up and it works fine.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmm

 

[smiley0q0]

my input mask works fine.

it's when i have created a list box that it just hows the numbers.. ie
4352542956

instead of
(435) 254-2956

looking at it in the table as well as queries, it looks like it should, it's just in the list box that it doesn't "look right"

Thanks
Smiley