How do you keep field lables with the field they belong to?

C

Christine

If you have a label for a field, how do you ensure the
label stays with the field below it? If my report goes
into a second page for example, the label appears on the
1st page, and the field data on the 2nd page!

I tried redesigning my report so that the field label is
on the right. However, if a field can grow (such as a
memo field), the label doesn't grow with the field. The
result is that the label border is too short. (Both the
label and the field have borders so it looks like a real
form.

Thanks to all,
Christine
 
L

Larry Linson

You write as though CanGrow works horizontally, but it only grows
vertically -- thus, that is definitely not the problem with labels not
aligning with the data. Perhaps you could clarify.

I have never experienced anything that would seem to fall under your
description of the problem, so without more information, I can't be of help.

Larry Linson
Microsoft Access MVP
 
J

John Spencer (MVP)

UNTESTED SUGGESTION

Try attaching the label to the control and see if it stays with the control.
To do so: Click on the label, Cut it, Click on the control (field) and paste.

This should bind the label control and the textbox control together. I don't
know if Access will then keep the two on the same page when you print, but it is
worth a try.

Let us know if this works. In the meantime I will think about other possible
solutions. One thing that comes to mind would be to use a sub-report for the
label and control, but that would seem to be an overly-complex solution.
 
Top