=(("H:"+[Home Number]) & (" C1:"+[Cell 1]) & (" C2:"+[Cell 2]) & (" B1:"+[Bus 1]))


For the above field, how can I get the fields Home Number, Cell 1, Cell 2 and Bus 1 to display in the report in the telephone number format as follows:

(999) 999-9999



Thanks, Jesse

What is the current format of each phone number? I would assume they are all text fields.

What is the current format of each phone number? I would assume they are all text fields.

Yes each of the controls are text fields with a phone number input mask. That much I know. In fact, the table shows all the correct format, and that is why I am perplexed by the lack of the same format in the report (Note: some of the entries display the correct format in the report but I only recently added the input mask, so some of those may be due to the fact that the parenthesis and dash were inputed as such)

Thanks for your time.

-Jesse

Reports don't hold table formats. When you want formatting, apply it at the last point of display. So, that would mean format it in the report.

Well Jesse, whatever you do will almost certainly require that all of the fields are in a consistant format.