Landscape and Portrait on one 'Report' page

A requirement of my application is to print an 'A4' page, the A4 page contains two A5 size labels, one of these has Landscape orientation, the other has Portrait orientation.

A solution based on Office 2003 would be ideal, failing that a solution based on acrobat would be a good second.
Thanks in advance.

John King
jking1234Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
OnALearningCurveCommented:
Hi John,

Depending on exactly what these labels need to look like you could produce them Using Access.  If you are looking to include images etc.. then it may be very difficult to do, but if they are simple text based designs then it may be possible.

If they are simply to be text labels with maybe a boarder around them then you might be able to do this.

I would produce a single A4 report and have the top half of the page laid out to be your A5 landscape label, then in the bottom half lay out your A5 Portrait label by "Vertical" Text boxes.  So your A4 Portrait report would print what seems to be an A5 landscape label on the top half of the page and an A5 Portrait label (sideways on) on the bottom half of the page.

Hope this makes sense,

Mark.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
jking1234Author Commented:
Thanks, that does the trick. I've been around MS Access since 1993, never knew about 'Vertical'
0
 
OnALearningCurveCommented:
Glad I could help John,

Just one pitfall to watch out for.  For some reason in my experience access will not display text in vertical boxes for no obvious reason.  After looking into this it seems to just not like certain Fonts.  So if you set a box to ertical tyoe and the text seesm to dissapear try changing the font.

Hope this helps,

Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.