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