report margin

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.

All I mean is using coding in module. Thanks

"-003KobeBrian" wrote in message
...
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.

can anyone please help? This is urgent. THanks.
"-003KobeBrian" wrote in message
...
All I mean is using coding in module. Thanks

"-003KobeBrian" wrote in message
...
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.

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


"-003KobeBrian" .gbl...
can anyone please help? This is urgent. THanks.
"-003KobeBrian" wrote in message
...
All I mean is using coding in module. Thanks

"-003KobeBrian" wrote in message
...
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.

"00kobebrian" wrote in message
...
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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.


"Rick Brandt" wrote in message
. com...
"00kobebrian" wrote in message
...
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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.


-003KobeBrian wrote:

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.

"Rick Brandt" wrote in message
. com...
"00kobebrian" wrote in message
...
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com