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;