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

[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

 

[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

 

[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.

 

[Christine]

Larry and John,

First, John's suggestion didn't work. The label
describing the field ("lblSolution") appeared on the
first page whilst the table field output("Solution",
which is a memo field and can grow) went to the second
page. John is right that grouping would be WAY too
complicated and not really appropriate, since each field
on the report stands by itself.

As for John's question to me, I understand that Can Grow
only works horizontally. When I couldn't get the label to
stay with the output when the bottom of the report page
margin is rearch, I tried puttingthe label to the left
with the output to the right. I have each field boxed
with lines around them (see crude diagram below):

┌───────┐──────┐
│lblSolution │Solution │
└───────┘│ │
│ │
└─────┘
In this option, I was hoping that there is a way to set
the Can Grow option for lblSolution could match that of
the Solution. I realise this is probably a silly thing to
think of.

If there isn't any way to keep the label with the output,
perhaps all that can be done is to not put the label on
the right and output to the left, without borders. What
do you think?

 

[Christine]

Larry and John,

First, John's suggestion didn't work. The label
describing the field ("lblSolution") appeared on the
first page whilst the table field output("Solution",
which is a memo field and can grow) went to the second
page. John is right that grouping would be WAY too
complicated and not really appropriate, since each field
on the report stands by itself.

As for John's question to me, I understand that Can Grow
only works horizontally. When I couldn't get the label to
stay with the output when the bottom of the report page
margin is rearch, I tried puttingthe label to the left
with the output to the right. I have each field boxed
with lines around them (see crude diagram below):

┌───────┐──────┐
│lblSolution │Solution │
└───────┘│ │
│ │
└─────┘
In this option, I was hoping that there is a way to set
the Can Grow option for lblSolution could match that of
the Solution. I realise this is probably a silly thing to
think of.

If there isn't any way to keep the label with the output,
perhaps all that can be done is to not put the label on
the right and output to the left, without borders. What
do you think?