ac2000 report sizing

[Colby]

I have a report in Access 2000 that needs to be a specific
height everytime it is opened (7" on an 800x600 18 flat
panel). I go into the design view of the report and
extend the bottom portion of it by 1/4", save and then
close it. I then open it and it is the desired size.
however, if I close it then open it again, it resumes the
original size which is the aforementioned 1/4" short.
Their are multiple headers that are set to the size that
they need to be, and other than this display issue the
report is perfect. In short, is there a way to fix the
display size in VBA code, or any other way for that matter?

Thanks for any help,

Colby

 

[Guest]

Set autoresize property to No but I'm not sure if that
goes back to ac2000. If not there is a save specific
report option in print setup i believe. This causes the
report to stay as you designed and not return to defaults.

 

[Alick [MSFT]]

Hi Colby,

Is the bottom portion you mentioned report footer or page footer or
something else? You can try the code like blow in report open event to
specify the height.

ReportFooter.Height= 600

Please feel free to reply to the threads if you have any questions or
concerns.



Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.






--------------------
| Content-Class: urn:content-classes:message
| From: "Colby" <[email protected]>
| Sender: "Colby" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have a report in Access 2000 that needs to be a specific
| height everytime it is opened (7" on an 800x600 18 flat
| panel). I go into the design view of the report and
| extend the bottom portion of it by 1/4", save and then
| close it. I then open it and it is the desired size.
| however, if I close it then open it again, it resumes the
| original size which is the aforementioned 1/4" short.
| Their are multiple headers that are set to the size that
| they need to be, and other than this display issue the
| report is perfect. In short, is there a way to fix the
| display size in VBA code, or any other way for that matter?
|
| Thanks for any help,
|
| Colby
|