Can Grow Question

  • Thread starter Thread starter T.J.
  • Start date Start date
T

T.J.

I have two questions regarding MS Access Reports. The
first is regarding the "Can Grow" feature. I have a
report built to have side by side column information. The
column on the right contains a "Notes" field so I set this
field's Can Grow property = yes. It grows correctly, but
when it grows the field in the left column of the report
will grow with it.

Like this....

Name Notes
Joe Smith Went to the market to get
milk and eggs for breakfast.
But the market was bare.
8801 West 3rd
Kansas City, Missouri

The main problem is in the right column directly below the
Notes field is another field. So if I stretch this field
down then the fields below are out of place if Can Grow is
not needed.

My second question is regarding the "Repeat Section"
value. I want the header to repeat on each page, and this
works correctly. The only problem is if this header is at
the bottom of the previous page and prints with no room
for information underneath it, then the next page
correctly repeats the header with the information.

Is there anyway to get the header at the bottom of the
previous page to disappear?

Thank you for your help,

T.J.
 
First Problem. Try concatenating the Name and address all into one control.
That will take care of the problem of the Notes growing.

Control Source: =[ClientName] & Chr(13) & Chr(10) & [StreetAddress] & Chr(13)
& Chr(10) & [City] & ", " & [State]

Make sure your control has a different name than the fields you want to combine.

2nd problem:
Set the Header's together property to print with at least one record in the detail.
 
Back
Top