Solved

MoveSize in reports

Posted on 2006-06-20
4
240 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
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

828 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