I have a report based on an individual record containing amongst other things a number of memo fields which can contain a large amount of text - or none. So the report can be anything from 1 to several pages long depending on the verbosity of the user!

I have built a report which contains all these fields as text boxes (all set as can grow & can shrink), with the attached labels above each box. This works fine, but when printing (or previewing) the label can become detached from its text box which moves to the next page.

Is there any way I can force the label to remain attached to its box - ie by forcing a page break before the label?

The extreme case is where a text box is too big for one page - it would be nice to be able to repeat the attached label at the top of the next page.

The whole thing has to be quite dynamic since each of these boxes can contain any amount of text.

Any ideas (a VBA answer is fine)?

Thank you.

David Trickett

I don't know if this will help but, are the labels "linked" to the textboxes. If they are, they may move with the textbox. I'm not sure what the proper Access term is but when you click on the text box does the label also get selected? If not, you can try reattaching the label to the text box. To do this, select the label and delete it. Then select the textbox and paste the label. This should re-attach the label and you will need to reposition it so that it is at the top of the textbox rather than to its side.

Pat

Thanks for this. The labels are all linked to the text boxes, but Access does separate them from their linked boxes at a new page. Another helpful MS feature!

David:(