keek2a4
03-02-2010, 07:57 AM
Hey Guys,
I have an access application and have modified the margin so that the report content fits properly. It works fine on my machine but when I put it on a shared location and have it accessed by other pc's, the margin setup changes. I get the message "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank" and prints un-necessary blank pages inbetween of the report pages.
Is there a way I can specify the margins in VBA code maybe in a OnOpen even? So if the user goes to file >> print, it picks up the margin from the VBA code rather then the default margin.
Thanks,
Ket
I have an access application and have modified the margin so that the report content fits properly. It works fine on my machine but when I put it on a shared location and have it accessed by other pc's, the margin setup changes. I get the message "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank" and prints un-necessary blank pages inbetween of the report pages.
Is there a way I can specify the margins in VBA code maybe in a OnOpen even? So if the user goes to file >> print, it picks up the margin from the VBA code rather then the default margin.
Thanks,
Ket