Search results

=Format([HomeNumber],">""H. (""@@@) @@@-@@@@ ") & Format([WorkNumber],">"" W. (""@@@) @@@-@@@@") Yours works but this is better

Tried it didn't work =Trim([LastName] & ", " & [Title] & ". " & [FirstName]) =Trim([Address]) =Trim([City] & ", " & [State] & ". " & [Zip]) =Trim("H. " & [HN] & " W. " & [WN]) WorkNumber HomeNumber

Tried it didn't work =Trim([LastName] & ", " & [Title] & ". " & [FirstName]) =Trim([Address]) =Trim([City] & ", " & [State] & ". " & [Zip])=Trim("H. " & [HN] & " W. " & [WN])WorkNumber HomeNumber

Using labels wizard I need a line for home and work # H. (###)###-#### W. (###)###-#### The table has phone # input mask The query has phone # input mask I can put an input mask on my label ony if I have one phone # only with no H. OR W.

I need a line (H. (###) ###-#### W.(###) ###-#### ) on my label. I can format it with an input mask only if one number alone is on a line of the label will not work if I put H. W. etc. or if I put two controls on a line.

. in my table the phone number is a text with an input mask for phone numbers. What should my format be?

Thanks you for your reply. in my table the phone number is a text with an input mask for phone numbers. What should my format be?

could you be more specific, as to where and what format ,have input mask now

used label wiz. to make adress and phone # labels. Everything is fine except that on the label the phone number transfers as ten digits in a row 000000000 and not as on my table or query (000)000-0000 what am I doing wrong