unbound text box too large for first page

[Mizzoug]

Hi,

Thanks in advance for any help.

I have an unbound text box in the detail section of a report that can be anywhere from a couple of lines to more than 90, depending on what items have been selected elsewhere. I've gotten the size of the textbox and detail section to vary using .height and allowing for 270 per line. All this works fine and everything prints. However...

The problem is that with the reports where this textbox won't fit on the first page, the detail section doesn't begin printing anything until the second page. It will then break across pages 2 and 3 just fine, but I would like it to start printing on page 1 whether it will fit or not. Research shows it has something to do with the "on retreat" event, but I can't find enough to figure out what to do.

Any suggestions?

Thanks again,
Mizzoug

 

[bob fitz]

Have you tried setting the "Can Grow" and "Can Shrink" properties of the text box instead of setting its height.

 

[vbaInet]

Also look at the Keep Together and Force New Page properties of a section. You've probably set one of them.

 

[Mizzoug]

Hi,
Thanks for the replies.

Yes, I've tried the Can Grow and Can Shrink properties both set to YES of the detail section and the text box (and auto height for the section). It won't print anything. If I set autoheight to no, prints nothing. If I set Can Shrink to no in both places, it prints whatever fits in the textbox I've drawn, nothing more. I guess it doesn't really grow unless there's bound textboxes in there, not an unbound one.

I have Force New Page set to no. I have Keep Together set to Yes because when I set it to No, it only prints whatever fits in the text box I've drawn.

For more info, I set the height in the On Format procedure for the Detail section. It does make it the right height to fit everything, but from my research, when Access figures out that everything won't print on the first page, it retreats and recalcs blah blah and my two extra long text boxes ended up starting on page 2.

Thanks again.
Mizzoug

 

[vbaInet]

... I have Keep Together set to Yes ...

For more info, I set the height in the On Format procedure for the Detail section.

Keep Together will attempt to keep the entire section on one page so if that section doesn't fit it will simply put the entire section on the next page. And you're forcing the section to keep to a certain height as well which doesn't help matters.

 

[Mizzoug]

Thanks for the reply.

So what would you recommend?

If I don't set the height and set Keep Together to No, it only prints whatever fits in the size of the box I draw. It doesn't grow at all.

If I don't set the height and set Keep Together at Yes, it only prints whatever fits in the size of the box I draw.

If I set the height (which changes with the amount I need to print), and set Keep Together at No or Yes, it starts printing on page 2 for the large ones.

Basically I have to set the height or it won't grow at all. Keep Together doesn't seem to matter (I think when I tested Keep Together before the Can Grow/Can Shrink must have been set incorrectly).

Thanks,
M

 

[vbaInet]

If I don't set the height and set Keep Together to No, it only prints whatever fits in the size of the box I draw. It doesn't grow at all.

If I don't set the height and set Keep Together at Yes, it only prints whatever fits in the size of the box I draw.

If I set the height (which changes with the amount I need to print), and set Keep Together at No or Yes, it starts printing on page 2 for the large ones.

Cache 22 Mizoug!

I'll need to see the db (with some test records).

 

[Mizzoug]

Hey vbaInet,

Thanks so much for taking the time. Sorry to take so long to get this to you. I've left two records - Student1 has the problem, Student2 does not.

Thanks,
M

 

[vbaInet]

It's not a very good report to look at in design view. It could do with some tidy up.

See if the attached is what you're after.