Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2007

Tip: Looking for answers? Try searching our database.

AutoShrink/AutoGrow doesn't work in reporting...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ilya - 11 Dec 2007 13:03 GMT
Hi, all!

Something really weird happens to one of the reports in our
application.
There is some field that gets it's value within the Detail_Print event
of the report. The field has Wuto Shrink and Auto Grow properties set
to "yes".
The weird thing is that for some reason some lines of this property do
not grow enough (like for 4 lines it makes space only for 3 and one
line is cut down) and for some lines it grows too much (for one line
it grows to accommodate 4 lines which results in mane wasted space).
I tried to use some API's to get the real width of the text that
should be printed within the control but this has no much help because
I can't set the Height property of the Detail object and the Height
property of the field while running in Detail_Print event.

Does anybody has a clue for this problem or some workaround?
All I need is the report to show the text which can be of different
length and I need to see all its contents without wasting space for
blank lines.

Another problem in the same report is that in Print Preview view I do
not see all the information the report actually shows. It means that
if I print the report as is it will print the information that is not
shown in Print Preview but should be shown. For example, one line of
the data I need to shrink/grow dynamically for, is blank but when I
print it out the data is printed.
The way to "fix" is to open the Page Setup by right clicking on the
report and just pressing OK without changing a thing...
Anybody has solution for it?

Thanks in advance,
Ilya
John Spencer - 11 Dec 2007 13:38 GMT
Could you use the FORMAT event instead of the PRINT event?  Does that make a
difference?

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Hi, all!
>
[quoted text clipped - 29 lines]
> Thanks in advance,
> Ilya
Ilya - 11 Dec 2007 16:26 GMT
> Could you use the FORMAT event instead of the PRINT event?  Does that make a
> difference?
[quoted text clipped - 39 lines]
> > Thanks in advance,
> > Ilya

Hello John,

Actually I've found a workaround: if within the query I send the data
to a function to format it as needed and then the field is set to be
bound to that field, the shrinking/growing works fine. Only when the
field is unbound and is changing in the print event the problem
occurs.

Next time I'll try the format event as you propose.

Thanks for your quick reply,
Ilya
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.