Improve company productivity with a Business Account.Sign Up

x
?
Solved

MoveSize in reports

Posted on 2006-06-20
4
Medium Priority
?
314 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 2000 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

589 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