Report and report preview are not properly displayed

[djemy1975]

I have a form in access with two buttons .The first is to display a print preview and the second is to display report view ,but they are displayed either in small form or cut off as the attached images show:

Please help me overcome this problem.

 

[djemy1975]

https://drive.google.com/drive/u/0/folders/0B-ngEx-v4UxPSExOSjBsYkZ6S0U

JUST SEND ME REQUEST FOR ACCESS AND I WILL GIVE YOU ACCESS

 

[HiTechCoach]

https://drive.google.com/drive/u/0/folders/0B-ngEx-v4UxPSExOSjBsYkZ6S0U

JUST SEND ME REQUEST FOR ACCESS AND I WILL GIVE YOU ACCESS

So other may benefit, it must be visible to everyone for me to help you for free.

 

[djemy1975]

So other may benefit, it must be visible to everyone for me to help you for free.

https://drive.google.com/drive/folders/0B2if4EvJUxEeYmVTdTNodlZYdzA?usp=sharing

Sorry ,I have limitted knowledge of sharing links.Checks now if the screenshots are available for you.

Thanks for your interest in my subject.

 

[xenou]

Probably a dumb question but have you tried dragging the corners of the window, double clicking the title bar, or hit the maximize button? In other words, resizing the report window.

 

[HiTechCoach]

https://drive.google.com/drive/folders/0B2if4EvJUxEeYmVTdTNodlZYdzA?usp=sharing

Sorry ,I have limitted knowledge of sharing links.Checks now if the screenshots are available for you.

Thanks for your interest in my subject.

Great job!. I can see the images.

What is happening is the report is oping in a window that is not maximized.

1) use the mouse: click the windows maximize icon on the title bar. This is the icon with a square to the left of red X (close) in the upper right corner of the window.

2) you might also consider adding this to the on open event of the report.

Private Sub Report_Open(Cancel As Integer)

    ' maximize the report window
    DoCmd.Maximize

End Sub

 

[djemy1975]

I have added the piece of code but the report has taken all the window.Is it possible to display it in a normal window on the form?

 

[xenou]

You can set window placement with the method discussed here:
https://msdn.microsoft.com/en-us/library/office/ff197394.aspx

 

[djemy1975]

where to add this code ?

 

[djemy1975]

Thank you so much I was able to solve this issue by playing on the code of your post as follows:

DoCmd.OpenReport "tblInvHeader", acPreview, "", "", acNormal
 DoCmd.MoveSize 12000, 1000, , 13000

I will attach a screenshot soon

 

[HiTechCoach]

Thank you so much I was able to solve this issue by playing on the code of your post as follows:

DoCmd.OpenReport "tblInvHeader", acPreview, "", "", acNormal
 DoCmd.MoveSize 12000, 1000, , 13000

I will attach a screenshot soon

You're welcome. Glad we could assist.

Thanks or the update and paying it forward with your solution.