Stretching labels to match the data

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a report that has fields such as Product Name,
Ingredient, and Notes. I have arranged the report to be
tabular with the labels on the left side and their values
on the right side. The problem is that the Ingredients
and Notes fields which have a type of memo and can be
quite long. I have it so that they can strech downward
which they often do and have placed solid borders around
them. I also placed solid borders around the label names
on the left and have them stretch. But, of course they
do not strech since the values in them don't change. I
want it so that the labels on the left will stretch with
the fields to the right so that it looks like two solid
boxes side by side with the same heights rather two boxes
of differeing heights.

Can anyone help?

Thanks,

Chuck

Can anyone help?

Thanks,

Chuck
 
Duane,

Thanks for you help. Unfortunately I am unable to open
the file from this site. I can unzip them but get error
messages saying that Access need to close. I have Access
XP. Is there a quick way to make the boxes around my
labels stretch or is there some programming involved?

Thanks,

Chuck
 
The only method is to use programming. You must include code in the On Print
event of the section containing the controls. The code would capture the
"grown" height of the text box and use the Line method of the report to
"draw" a box around the label. The label itself would have no border.
 
Back
Top