The reports in Access should be more versatile

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access Database that has a few text-heavy fields. When I generate
reports, I am always frustrated that the report fields don't expand and
contract like a cell in Excel does (if you use the text wrapping feature). I
would love to see future versions of Access that have that versatility. I
also have a report (with a subreport included) that for some reason always
starts a new page at the end of each record unless the record is very short.
I cannot find a way to stop it. Easier controls for page setup and creating
and deleting page breaks would be great.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...67d853f111&dg=microsoft.public.access.reports
 
you can make the controls in a report "expand and contract" by setting the
control's CanGrow and CanShrink properties to Yes, and ditto the properties
of the section that the control is in.

hth


totoraib said:
I have an Access Database that has a few text-heavy fields. When I generate
reports, I am always frustrated that the report fields don't expand and
contract like a cell in Excel does (if you use the text wrapping feature). I
would love to see future versions of Access that have that versatility. I
also have a report (with a subreport included) that for some reason always
starts a new page at the end of each record unless the record is very short.
I cannot find a way to stop it. Easier controls for page setup and creating
and deleting page breaks would be great.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...67d853f111&dg=microsoft.public.access.reports
 
Tina:

You're my hero and I feel so stupid! I have used the "can grow" feature so
many times to ensure that multiple records in a subfield will display under
each related record in my report, but it never occurred to me to find and
turn on the "can grow" feature specifically relevant to the field box I
wanted to expand. Your advice just improved my report immensely. Thank you!
 
you're welcome :)


totoraib said:
Tina:

You're my hero and I feel so stupid! I have used the "can grow" feature so
many times to ensure that multiple records in a subfield will display under
each related record in my report, but it never occurred to me to find and
turn on the "can grow" feature specifically relevant to the field box I
wanted to expand. Your advice just improved my report immensely. Thank you!
Click to expand...
 
Back
Top