report margin

[-003KobeBrian]

How do I set up report margin using coding in a event or module? and How do
I move all the controls in pageheader by 2 cm downward? Please help. Thanks.

 

[-003KobeBrian]

All I mean is using coding in module. Thanks

 

[-003KobeBrian]

can anyone please help? This is urgent. THanks.

All I mean is using coding in module. Thanks

 

[00kobebrian]

Since there is no reply, can I assume there is no way to do it? PLease
confirm for me. Thanks.

 

[Rick Brandt]

Since there is no reply, can I assume there is no way to do it? PLease confirm
for me. Thanks.

It means that no one who has read your question has ever had any reason to
attempt to do so.

I suspect that there is a more conventional way to solve your problem than the
way you are attempting. Why not describe the core problem you are trying to
solve? Perhaps changing margins and moving things around on the page are not
required to solve it.

 

[-003KobeBrian]

OK. I got 100 reports existing. Now I found that I need to have a page
header with company logo in all the reports. I already figured out how to
use coding to generate the header and logo to each report. But the top and
bottom margin is not right and existing control need to move down for the
new company logo. Instead of going to 100 reports and change them manually,
I wonder if I can use code or macro to do it automatically. That's my
scenerio. Hope anybody can help. Thanks.

 

[John Spencer]

Yes, you can do this in code for a report. What VERSION of Access are you using.

I'm not sure how you can change the MARGINS on a page. But you can expand the
size of the page header and move all the controls down and save the change.

You will need to step through each report in the reports collection,
--Open a report in design view,
--change the height of the page header by adding to the size (1440 * size in
inches) plus current height
-- Cycle through all the controls in the header and add to the Top value of each control
-- Create a control on the form
-- Save the form.

If you are using earlier versions of Access check out PrtMIP in the VBA Help. I
am on a computer right now that doesn't allow me to get to Access.