Report Page Setting

[saleem]

Is there a way to set report page margin viz code. I want my report to left 0.5" from left,right,top and bottom, but each time i close and reopen the report, its page setup changed. I have to manually set it each time i need to print report.

I dont know y this is happening..any idea..I think i should code page set-up via code and put it in the on load event of report. But what the code be..i cant figure out..anyone pl help

thks

saleem ahmed

 

[Rich]

If your using A2k there's a bug in the Auto correct feature, turn it off, or search the MS knowledge base for a patch.
HTH

 

[D B Lawson]

Something else that I found helped was to change the default print margins (Tools/Options/General) to 1cm all over so that if it does reset itself you get the maximum print area.

 

[saleem]

I tried both but none of the suggestion work. Is there sny other way?

 

[R. Hicks]

When you make the changes to the margins in the report ... you must save the change or they will revert back to what they were.

RDH

 

[saleem]

i m saving it Hick but its reverting back to 1" from each side instead of of i fixed..0.5" from each side !!!!

 

[R. Hicks]

If you are using Access 2000 then you may have the original release. This problem existed in the original release. To fix the problem you need to install the Service Release patch from Microsoft as Rich suggested in his reply.

Here is a link to the location where you can download the patch file.

Lost Printer Settings in Access 2000

RDH

[This message has been edited by R. Hicks (edited 01-20-2002).]

 

[saleem]

I ran macro in excel and it generate this code for page setting with 0.5 inch from each side...i need same code for my access report..can any one help


Sub pgsetup()
'
' pgsetup Macro
' Macro recorded 01/21/2002 by saleem
'

'
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.5)
.TopMargin = Application.InchesToPoints(0.5)
.BottomMargin = Application.InchesToPoints(0.5)
.HeaderMargin = Application.InchesToPoints(0.5)
.FooterMargin = Application.InchesToPoints(0.5)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 300
.CenterHorizontally = False
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperLetter
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 100
End With
End Sub

 

[ghudson]

Is there a way to set report page margin viz code. I want my report to left 0.5" from left,right,top and bottom, but each time i close and reopen the report, its page setup changed. I have to manually set it each time i need to print report.

I dont know y this is happening..any idea..I think i should code page set-up via code and put it in the on load event of report. But what the code be..i cant figure out..anyone pl help

thks

saleem ahmed

I needed this today. There were no posts on this forum that had the answer...until now.

        Printer.TopMargin = 1
        Printer.RightMargin = 0.25
        Printer.LeftMargin = 0.25
        Printer.BottomMargin = 0.5

 

[crmarrio]

Same problem with Win XP Pro & Access 2003

Hi,

Am having the same problem with report settings disappearing on save

Can set all the report-specific printing options and everything works fine, until you save the report and re-try. Then some - but not all - of the settings disappear.

e.g. I need Report 1 to be from Tray 2, Duplexed and Stapled.

I need Report 2 to be from Tray 3, Duplexed and delivered to Stacker Tray (not top bin)

After saving, the reports print from the correct trays, but the duplex and stapling options disappear.

The printer is an HP LJ 4350 DTNSL - using the PCL 6 driver from HP website.

Any help really appreciated - I've check the Name Correct thing to see if it makes any difference but it doesn't.

Chris