How do I .....

[Noreene Patrick]

I asked a question yesterday (and got a quick answer) about how to fit report to window.

My report still has a gray area across top and left side where the report doesnt completely cover all area. I can scroll the report to make it fill the page, but is there a way to have the report completely fill the preview area? Or was this supposed to happen when I put in:

DoCmd.OpenReport "Calendar", acViewPreview
DoCmd.RunCommand acCmdZoom100

The gray border is about .5 across top and down left side.
I have worked with page setup and tried to set margins to compensate but so far cant figure it out.

Thanks for your help

 

[Rich]

Use the open event of the report to Maximise it

 

[Noreene Patrick]

Thanks, Rich

The gray area is still there just around the left side and top

 

[yellow]

If I understand what you are saying......As far as I am aware it is not possible to remove the grey border. You are print previewing your report.

 

[Noreene Patrick]

Okay, thanks for replying..

Noreene