Report truncating memo field

S

Sandy Boswell

I have created a recipe database. My recipe report prints 4 3x5 recipes in
landscape on 11 x 8 /12 page. My header contains the recipe name,
description, calories. My detail section contains a subreport of ingredients
(3 columns) (set to "can grow = yes") and a directions memo field (also set
to "can grow = yes"). The report size is 3x5 (set to can grow = no") so each
recipe remains on the 3x5 card. This works beautifully until the directions
flow past the 3x5 card size.

Is there any way to repeat the header to a second 3x5 card with the the
remaining directions?

Thanks for any help you can give me.
 
M

Marshall Barton

Sandy said:
I have created a recipe database. My recipe report prints 4 3x5 recipes in
landscape on 11 x 8 /12 page. My header contains the recipe name,
description, calories. My detail section contains a subreport of ingredients
(3 columns) (set to "can grow = yes") and a directions memo field (also set
to "can grow = yes"). The report size is 3x5 (set to can grow = no") so each
recipe remains on the 3x5 card. This works beautifully until the directions
flow past the 3x5 card size.

Is there any way to repeat the header to a second 3x5 card with the the
remaining directions?


Try using the Page header instead of the report header.
 
M

Marshall Barton

Sandy said:
I have created a recipe database. My recipe report prints 4 3x5 recipes in
landscape on 11 x 8 /12 page. My header contains the recipe name,
description, calories. My detail section contains a subreport of ingredients
(3 columns) (set to "can grow = yes") and a directions memo field (also set
to "can grow = yes"). The report size is 3x5 (set to can grow = no") so each
recipe remains on the 3x5 card. This works beautifully until the directions
flow past the 3x5 card size.

Is there any way to repeat the header to a second 3x5 card with the the
remaining directions?


Please keep the correspondence in the newsgroups.

Copy of email followup-----------
Unfortunately this won't work in my case. I have four
different recipes to the page. If I put the recipe name
in the page header, it will only print one recipe name
for four different recipes. Also the remainder of the
memo field still does not print.
I know I can set the detail field to "can grow = yes"
and get the entire field to print, but then remaining
recipes are skewed.


I had assumed that your page size was 3x5 and that you had
some kind of printer 4 up feature that let you print those
"pages" on a single sheet of paper. In this situation
letting the detail grow would be ok.

It now sounds like you are using the equivalent of a label
report. In this case you don't want the detail section to
grow, but you do want it spill over into another detail
section. If that's the kind of thing you're looking for,
then I can not think of a reasonable way to do that using a
proportional font.

With a fixed font (e.g. Courrier), it would be possible, but
not easy, to split the memo field into pieces and put them
in separate detail sections.
 
M

Marshall Barton

Sandy said:
I hope I'm submitting this correctly; I'm new to submitting to newsgroups.


Thanks for your input. Yes, that's exactly what I'm looking for. I don't
mind using a fixed font.


Can you tell me where to find instructions for this? It would be great if
the group header could repeat, also. If that is not possible, I can be
satisfied with just getting all of the detail to print.


I am unaware of any instructions for doing such an unusual
thing as this.

I thought I could figure out a way using a significant
amount of rather slow VBA code in the detail section's
Format event, but the precision of calculating text size is
just not good enough. So scap that usless thought.

I am afraid that, unless someone else has a better idea, you
may have to resort to fudging your data by manually
splitting the directions into two (or more) records. To
make this come out right on the report, add a field to the
table for CardNumber. For the second card, use the same
recipe name, and set the card number field to 2. Add the
CardNumber field as another level of sorting to the report
to keep the cards in the right order.

I guess you'll need to use trial and error to figure out how
much text has to be moved to the second record. Whether you
use a fixed or proportional font won't make any difference
in this wimpy approach.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top