Can Grow Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T.J. - 09 Jan 2004 18:40 GMT

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.

Reply to this Message

spencer4 - 10 Jan 2004 15:49 GMT

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.

> I have two questions regarding MS Access Reports. The
> first is regarding the "Can Grow" feature. I have a
[quoted text clipped - 31 lines]
>
> T.J.

Reply to this Message

MrSnid - 13 May 2008 15:31 GMT

I have a similar problem, hoping you might be able to help me out as well.

Is there a way to reference another Field's property in the field property of
another field.

For Instance, I would like Field194 to have the same dimensions of Field294
where Field294 Can Grow=Yes.

Thanks!
Mr Snid

>First Problem. Try concatenating the Name and address all into one control.
>That will take care of the problem of the Notes growing.
[quoted text clipped - 12 lines]
>>
>> T.J.

Reply to this Message