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 2004

Tip: Looking for answers? Try searching our database.

Acc97 detail section can shrink doesn#t work !!!!!!!! HELP ME !!!!!! SOS !!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
basti - 30 Dec 2004 09:23 GMT
My Prob:
I'm having a standart access97 report . In the detail section i have a
Image object that changes its size on the on formatevent, because the
images have different sizes. Every time the image is bigger than ist
forerunner it is no problem. Access Grows the detail section as it
should be. But in the moment the image is smaller than its forerunner
the height of the detail section stays where it used to be. this
mieans the shrink mechanism doesn't work. Why. is this a known bug ?
is there a solution ?
I tried everything. I tried to put it in a subreport , i tried to
change the height of the detailsection by code on the format event,
but access said you can#t do that, i even prayed to the lord for an
inspiration , although i am an atheist, but it all led me into
darkness. now i need a little light to help me out.

For any answer i thank and greet you out of the dark Fulda/Germany
Stephen Lebans - 31 Dec 2004 04:08 GMT
As you have discovered in A97, once you programmatically set the height
of a control the Section will never shrink below this value. A2K and
higher does allow you to programmatically set the Detail section's
Height in the Format event.

You may be able to use the workaround detailed here but in my opinion
it is not a 100% viable solution because it is a PITA!
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> My Prob:
> I'm having a standart access97 report . In the detail section i have a
[quoted text clipped - 12 lines]
>
> For any answer i thank and greet you out of the dark Fulda/Germany
 
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.