Format phone number in an unbound list box

[kbremner]

How do I format a phone number (entered as text field) to display " (123) 456-7890 " in an unbound list box populated by a query?

SELECT tblContacts.ContactID, tblContacts.FileName, tblClients.Client, tblContacts.Phone FROM tblClients ORDER BY tblContacts.FileName;

[ajetrumpet]

not sure. I wonder if you can mask a certain column of a listbox? I would doubt it though. I would think it best to put the phone number in a separate control if a mask is needed.

[pbaldy]

You can use the Format() function in the SELECT clause to add a formatted field.