Calvin-
It's been accepted as a bug my MSFT. No word on any solution. It probably has
a low priority.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
---------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Tuesday, May 22, 2012 5:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger
than hairline (Access 2007)
Calvin-
I tried dinking with the Top property of the second subform control in both the
Format and Print events of the Detail section. I was trying to push up the
second one just a skosh with code like this:
' Push the bottom subreport up a bit to take care of the gap
Me.Invoices.Top = Me.Order_Details.Top + Me.Order_Details.Height - 50
(Note that heights in code are in Twips - 1440 Twips to the inch.)
.. where Order_Details is the first subreport and Invoices is the second.
No joy. Apparently, the report engine hasn't calculated the final height of the
first subreport in the Format event. Moving the second subreport up at that
point does eliminate the overlap when all the rows to be displayed fit within
the design height of the first subreport. But the controls don't push down
until the Print event, and then I get invalid property setting if I try it at
that point. It would take getting an actual count of the number of rows in the
first subreport, calculating and setting the height and top "manually" - in the
Format event. The first subreport would have to have Can Grow set to No. Your
code would then set the height of the first one in code and the top of the
second subreport and all controls below it accordingly. It could probably be
done with a bit of tweaking, but the actual code would depend on your actual
situation.
That's a lot of work to get rid of this "buglet", IMO.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of c.krusen1
Sent: Tuesday, May 22, 2012 4:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger than
hairline (Access 2007)
Print each one out and the gap is very obvious.
I am really just trying to get rid of the gap - which only appears when the
border width is > hairline.
Calvin
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , John Viescas <JohnV@...>
wrote:
>
> Calvin & Bill-
>
>
>
> Tested in 2007 also. I see a slight gap between the two when border is 2pt,
but
> it doesn't get any bigger. I was careful to do an Align Top on the two
> subreports to they're exactly touching.
>
>
>
> John Viescas, author
>
> Microsoft Office Access 2010 Inside Out
>
> Microsoft Office Access 2007 Inside Out
>
> Building Microsoft Access Applications
>
> Microsoft Office Access 2003 Inside Out
>
> SQL Queries for Mere Mortals
>
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Tuesday, May 22, 2012 4:24 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger
than
> hairline (Access 2007)
>
>
>
>
>
> Calvin
>
> What version of Access are you using? I just tested in 2003 and the border
width
> does not affect the layout.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "c.krusen1" <c.krusen1@>
> wrote:
> >
> > There seems to be a gap between sub-reports that grows with the sub-report's
> border size. When it is set to hairline, the gap is not perceivable. But with
> larger sizes, it gets ugly.
> >
> > It's easily demonstrated. Just make a report, put two sub reports in it,
align
> the sub-reports, set their borders to hairline and print preview. Then change
> the sub-reports' borders to 2pt and print preview again.
> >
> > I've played with the various parameters of the sub-reports (padding, setting
> the Top value of the lower sub to just under the height of upper one, etc..)
> with no success.
> >
> > Anyone run into this, or have any solutions?
> >
> > Thanks in advance.
> >
> > Calvin
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar