H. (###) ###-#### shows as H. ##########

[Tigranes]

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.

 

[jatfill]

I've done this before & it works great for me...

Create two fields on your report, set their visible property to no and make sure their input mask is displaying correctly (preview them first & see before you make them not visible, if they don't show the correct input mask, set it on the field's property).

Each field should be bound to the numbers. In this example I call the two created fields "h_phone" and "w_phone"

Then create a new field, set the Control Source as follows:

= "H. " & [h_phone] & " W. " & [w_phone]

Try that & see if it comes up properly...

 

[Tigranes]

Tried it didn't work


=Trim([LastName] & ", " & [Title] & ". " & [FirstName])
=Trim([Address])
=Trim([City] & ", " & [State] & ". " & [Zip])=Trim("H. " & [HN] & " W. " & [WN])WorkNumber
HomeNumber

 

[Tigranes]

Tried it didn't work

=Trim([LastName] & ", " & [Title] & ". " & [FirstName])
=Trim([Address])
=Trim([City] & ", " & [State] & ". " & [Zip])
=Trim("H. " & [HN] & " W. " & [WN])
WorkNumber

HomeNumber

 

[jatfill]

sorry, I looked again at the example I was using and tested exactly what you're trying to do and it does not work...

but here's another idea that works great:


="H. (" & Left([home_tel],3) & ") " & Mid([home_tel],4,3) & " - " & Right([home_tel],4) & " W. (" & Left([work_tel],3) & ") " & Mid([work_tel],4,3) & " - " & Right([work_tel],4)


You won't need the two hidden fields, just change the [home_tel] and [work_tel] references to match the field names in your source table.

This brings up a good issue on table design... personally I split all telephone numbers into four different fields... area code, exchange, number, and extension. Input masks are nice, but splitting those fields, although it creates extras, makes it very easy to accomplish things like this without a lot of extra code on your reports. As far as forms and entering phone numbers, I use input masks to ensure the correct number of digits in each field and use the autotab function... users never know the difference when they are rapidly typing...

hope this helps... good luck

[This message has been edited by jatfill (edited 06-22-2001).]

 

[Tigranes]

=Format([HomeNumber],">""H. (""@@@) @@@-@@@@ ") & Format([WorkNumber],">"" W. (""@@@) @@@-@@@@")

Yours works but this is better

 

[Little_Man22]

Do you guys know how to change an input mask so that I can have spaces in between phone number digits. I need the output to resemble the following:

# # # - # # # #

Any ideas?