Solved

Landscape and Portrait on one 'Report' page

Posted on 2008-06-13
3
761 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
OnALearningCurve earned 250 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 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