ac2000 report sizing

  • Thread starter Thread starter Colby
  • Start date Start date
C

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
 
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.
 
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
|
 
Back
Top