?
Solved

Landscape and Portrait on one 'Report' page

Posted on 2008-06-13
3
Medium Priority
?
765 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:jking1234
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
OnALearningCurve earned 1000 total points
ID: 21778440
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
 

Author Closing Comment

by:jking1234
ID: 31467349
Thanks, that does the trick. I've been around MS Access since 1993, never knew about 'Vertical'
0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 21789902
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question