Listbox formatting 2

[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

 

[dhookom]

You may need to use something like:

"(" & Left([Home Phone],3) & ") " & Mid([Home Phone],4,3) & "-" & Right([Home Phone],4)

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Rich8541 . . .

A custom field will do. Assuming your field is named [blue]Phone[/blue], in an empty field in the field row of the query grid, copy/paste the following:

[blue]PH:Format([Phone], "@@@-@@@-@@@@")[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]