How to set the margins for header and footer of access reports

[ammoos]

Hi Friends,

I need to set the marigin of header and footer in my access reports, like Margins 10mm on all four sides of header and footer. Please help me

Thanks Ammoos

[ADezii]

@ammoos

1. I don't think that you can isolate Margin Settings for a Report's Header and Footer, but if you could, the syntax would be something similar to:
   

   Reports(conREPORT_NAME).Section(acHeader).LeftMargin = XXX
   Reports(conREPORT_NAME).Section(acFooter).LeftMargin = XXX
   'etc...

2. To programmatically modify the Margin Settings for a 'Report', you set specific Properties of the Report's Printer, keeping in mind that all settings are in Twips where 1 inch = 1440 Twips. Here is an example for you to follow:
   

   Const conREPORT_NAME As String = "rptTest"
   Const conTWIPS_PER_INCH As Integer = 1440
    
   DoCmd.OpenReport conREPORT_NAME, acViewPreview
    
   With Reports(conREPORT_NAME).Printer
     .LeftMargin = 0.75 * conTWIPS_PER_INCH         '3/4 inch
     .RightMargin = 0.5 * conTWIPS_PER_INCH          '1/2 inch
     .TopMargin = conTWIPS_PER_INCH                  '1 inch
     .BottomMargin = 1.5 * conTWIPS_PER_INCH         '1.5 inch
   End With

[ammoos]

@ADezii
Thanks very much ADezii