Trouble formatting a column in a list box...

[dionu]

I am trying to fill a list box with distinct rows from a query. I have the data filling the list box, but one of my columns within the list box contains phone number information. I have used an input mask defined within the table that stores the information and anytime I have called the field in a form, the input mask has come with it. I have also set it up to save the data with the characters, example (999) 999-9999, this is how it is saved.
I have tried everything I can think of and tried to research how many places in search of an answer to why the data is displayed as 9999999999 in the list box, and only in that one list box.

 

[bradmaunsell]

For what it's worth....
I had a somewhat similar issue. In my case, I found that formating had been applied in table itself. By removing the formating in the table, I was able to get control of the formating at form level.