Changing fields when previewing/printing

[brandie]

I print out layouts from FileMaker to integrate (by hand) into a Microsoft Word report. Essentially, I just have a page holder in Word, and when the report is generated, I print from FMP and slip the page into the report.

To keep page numbering consistent throughout, I have a text field in the footer of the layout where I type the page number. It's not a "Page Number" field that automatically updates, it's just a place where I key the appropriate number.

If I print a single record ("Current record"), it prints properly. However, if I print "Records being browsed", it alters the numbers, seemingly arbitrarily, raising them by two in this instance.

Why is it updating a field that is not tied or linked to any other fields, especially since the page numbers that it is changing it to, like 37, are nowhere near the actual print job page numbers? Is there any way I can fix this?

Or am I not explaining this well at all?

EDIT: Oh, and the changed field does show up with the incorrect numbers in the Preview mode...But the numbers are correctly entered in Browse mode.

Edited November 16, 2005 by Guest

[CyborgSam]

Brandie->

Welcome to the Forums.

If the field is not a global field, it will have a different value for each record. You're seeing page numbers from other records when you print multiple records (I assume they're left over from previous printings).

Set the field to global and try that.

[brandie]

Thanks for your response Sam.

I do want the value to be different for each record. When I'm printing the multiple records, they're full page records, thus each record should have its own unique page number.

[brandie]

Does anyone else have any ideas?

[Gar]

Is the "Page Number" field a simple text box, or are there any special settings (calculation, etc.), or are all entries manual?

Try placing your "Page Number" field in the body of the page rather than the footer, manually update your page numbers, and print records being browsed.

My understanding is the footer should contain the automated page number field and is better used for multiple pages for a single record (please correct me if I am wrong here).

[dkemme]

You would need enter the correct page number into each record that you are printing. If you only enter it into the first record and print records being browsed, the page number for the other records will be whatever valued was last entered into that record.

I would suggest using a calculation or summary field that added one each record browsing to get the correct page numbering.

[brandie]

It's a simple text box where I manually enter numbers. Moving things from the footer appears to have worked though! Thank you *so* much! This was driving me up a wall.

[brandie]

I was entering it for each record individually...not just the first one. It was still changing the numbers though when I printed. Gar's suggestion of moving it out of the footer section seemed to take care of the problem though.

[comment]

There is a box in the print dialog, where you can specify the starting page number.