Solved

MoveSize in reports

Posted on 2006-06-20
4
249 Views
Last Modified: 2008-03-06
Hi experts,

I am trying to open a report using a cmd button on my form.  I would like the report to open up at a specified size and not completely over the top of my form.  For example, the left hand side of the report should start at 5cm.  The top of the report should start at 4cm and the width of the report should be 15cm.

I have tried using the MoveSize command in VBA and also have tried creating a macro with the movesize command but this has not worked either.  I have no idea what I am doing wrong.  In the Access help it says that it is possible to MoveSize in reports, but it is not working for me.  The report opens in full screen print preview and when I click the very top left corner (app icon) the Move and Size are greyed out.  Can anybody help?

Thank you.
Terry
0
Comment
Question by:TerenceHewett
[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
  • 3
4 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 16940650
how did u use MoveSize? u need to ensure that has focus

e.g.

    DoCmd.OpenReport "Report1", acViewPreview
    DoCmd.MoveSize 1440, 2400, , 9000
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16940676
if your report is being opened maximised, then MoveSize has no affect so u could try adding this before MoveSize

DoCmd.Restore

and see what happens
0
 

Author Comment

by:TerenceHewett
ID: 17085866
Sorry Rocki for the late response.  Been on holiday for the past couple of weeks and just catching up.  I will try your suggestions, and come back with a new question if I have one.  

Best regards,

Terry
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17085884
No probs. Trust u had good hols
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

759 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