Set height of a reports detail using vba... and more

[srmousse]

I need to set the height of a reports detail using vba... how do you do that???

Also, how can I change the print settings, i.e. page boarders, paper size, printer, etc., also using vba... I can't find anything on it.

Thanks!!!

 

[llkhoutx]

O'Reilly's Access Cookbook has detailed infor on printer control for Access 2k, upwards.

Me.Section(i).Height = inches * 1440 'you have to convert to rasters (I think)

i = the report section (0, 1, 2, etc.)

change the header height on the report section OnFormat event.