listbox data (phone number) formatting 1

[Rich8541]

Hi, I have a listbox that is based on a query to return contractor info. Just one record based on a selection from a combo box. One of the fields is the phone number. In the query it is formatted to show dashes between the numbers such as 609-111-2222. But in my listbox the numbers have no dashes such as 6091112222. How can I get the dashes to appear in the listbox? And is there a way to word wrap the data in the listbox? I wanted the name and address to appear as it would on a letter for example, to save space on the form.
Thanks, Rich

 

[kjv1611]

Are the address and phone number in 2 separate list boxes or the same?

And actually, I'm having a hard time following this for some reason - are you saying you have the contractor name, address, and telephone number all listed in one list box? Any particular reason? A List Box is designed to be used for SELECTING data, not really for VIEWING it. For the best control of your data presentation, it'd be best to put the items in separate text boxes.

Or another thought/idea would be to use a subform that uses your query results as it's row source - maybe that'll give you the control you need?