Text-wrapping of Phone Numbers

[JohnHarkins]

Hi!

I'm doing a telephone directory for my wife and phone numbers are displayed "economically"; i.e., the report has two-column format. Text-wrap is helpful most times, but I want non-breaking spaces in order to keep together the designation of the kind of phone number and all parts of the associated phone number to be kept together from one line to another. A typical entry looks like this:

first_name last_name
555-1212 (W) 212 555-1212 (F) 555-1212
e-mail_name@e-mail_address.com (optional)
address_line_1
address_line_2 (optional)
city, state zip
...

This works fine. If, however, the fax number has an area code other than the "home" area code (such area code being omitted for phone numbers that are in the "home" area code), then I necessarily get text-wrap and I end up with:

first_name last_name
555-1212 (W) 212 555-1212 (F) 212
555-1212
e-mail_name@e-mail_address.com (optional)
address_line_1
address_line_2 (optional)
city, state zip
...

In the above case, I want:

555-1212 (W) 212 555-1212
(F) 212 555-1212

Suggestions?

Thanks, John Harkins

 

[67peshawar294]

John,
Are the three #'s in the same field as one long string?
If they are one long string, try reducing the height of the txtbox and increasing the length to get all the characters on one line.
This should work unless you have two columns on a report.
And it should work if you concantate the #'s

Probably the best way would be to have three fields;
HomePh
WkPh
FaxPh
Then you could set the numbers on a form or report any way you want them.
Jim

 

[JohnHarkins]

Thanks for the suggestions. There are three separate fields; however, I'd really like to find a way to combine word-wrapping with non-breaking spaces and concatenated strings in order to save space in the printout. I did a trial run with smaller type... and the client (actually the executive committee of the organization my wife's a member of) didn't like it--"too hard to read." I tried two entries on one line and the third on a second line... and the client didn't like it--"why can't the three numbers fit on one line if they all have the 'home' area code?" And so on.

You don't suppose there's a non-print character that would "display" as a space, is there?

I might be able to get away with slightly smaller font size... but with some persnicketiness on the client's part, that just won't cut it. Oh, well, I guess I could "count" characters using VBA and make the decision on which line to place the third number if an "out of area code number should force the information to another line.

Aren't clients wonderful?!

I do appreciate your suggestions.

Regards,
John Harkins

 

[67peshawar294]

John,
Are you using 81/2X11 and have you widened the margins on the report to max? Put the margins to .5 rt and lft maybe that would give you enough room.How about a more condensed font?
ANYTHING THAT WILL WORK!!!!
I am not a "guru" I just play around till I get it to work...
Jim