I need to be able to change the margins of a report from VBA based on values selected by the user from a form. PprtDevMode allows you to change orientation etc but not the margins.

Any help would be appreciated

You may have to develop two reports, one for each margin size. And then just call them accordingly...

Ken

Trouble is - the reports are acually letters and I need the user to be able to have any number of different letters based on their client requirements, so it is not feasible to have just 2 reports, because it may be that they need upto one hundred different letters.