Reports: Landscape question

mytfein used Ask the Experts™
Hi EE,

The screen shot below is in landscape mode.
Under page setup, I clicked 7 columns.
I was hoping to fit  TWO rows going across.

Instead report is going to a second page.
Please see screen shot below: There is alot of empty space on bottom of page that I would
like to utilize for more data.

Is this possible? Have uploaded test mdb below.
(btw, Access graphs is a nice feature, yet for other reasons resized rectangles to look
like bar graphs)
 tx, sandra

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Is this what you were looking for? I had to shorten the line dividing the columns.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Beyond what Flyster has posted, why not just shorten the Bars?


Hi Gentlemen,
thx sooo much for writing...
i did not realize to shorten controls....

i used both of your suggestions, below is an improved screen shot....
tx again, sandra

p.s. will be posting shortly w/ another related post....tx, s
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012



Hi Jeff,

Wanted to let you know where I am on this journey, so far... as you have been
an observer and coach (probably wondering the whole while about the unorthodoxy of this....)

Below pls find screen shot of report with moving arrow (it's near the bar positionally that it belongs to)
I did "the arrow" using line control and wingdings....

Right now I'm exploring finding a clip art arrow and modifying it in paint, to use as the arrow instead...
I know, I know (smile...) any questions, require a new post (this is just an update... no questionss
here... lol...) tx, s


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial