Gang-

I'm attempting to create a phone directory from an imported tab-delimined file. The format is as shown in the attached jpeg. (I've blurred the non-fictional entires to respect the privacy of the members.)

I have two issues with this.

Issue One:

As you can see from the non-blurred entries, I'm using the label feature of FMP to create a two column listing of "labels" with a page size that's the size of the directory page that's being printed. Though I'm not actually printing labels, this format seemed the best approach to create a directory listing. Line 1 contains the last name and first names of the adults in the household (this is all one field; not my choice) as left-aligned text and the phone number on that same line as right-aligned text.

This works well, for the most part. The problem occurs, as you can see, when there's too much text for the first line. In this case, the phone number is wrapping to the second line and breaking wherever it needs to.

What I would prefer happen is, if the phone number needs to wrap, the entire phone move to line 2 and right-align.

Using the label function as I have, I'm not sure how to accomplish this.

Am I going about this the right way? Should I be doing something other than the label function (a portal perhaps)?

Issue Two:

As is done in many directory listings (and encyclopedias and dictionaries), I would like to populate the header with the first entry and last entry from that page to make browsing easier (last names only). For example, the header of page 1 might read Aardvark-Anderson (from the first and last entires on page 1) and the header of page 23 might read Sloane-Smith (from the first and last entires on page 23).

Any thoughts on how to approach this?

Thank you for your thoughts.

Use non-breaking spaces to prevent phone numbers (or any other groups of "words") from wrapping between lines.

On MacOS a non-breaking space is Option-Space. I have no idea what is required to create one in WinOS.

FMP displays the first record on each page in the header, and the last record in the footer.

Thank you for your response. I'm hopeful that your suggestions will solve my problems, but I'm unclear how I should implement them. If there were a non-breaking hyphen (I'm on the Mac), this might work to keep the phone number from breaking across the line, but I'm not sure how I would implement that. In the current label format, the phone number entry is in the form <<phonenum>>, as it's in the merge format FMP uses for labels.

And, how do I tell FMP to include the first record in the header and the second in the footer. I've created headers and footers and put a copy of <<Name>> in each one. The header one seems to work just fine when viewed in preview mode but the footer one displays not the last entry of the page, but the FIRST entry of the NEXT page.

I appreciate your help with this.