ACCESS FEED: RE: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger than hairline (Access 2007)

Selasa, 22 Mei 2012

RE: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger than hairline (Access 2007)

Calvin-

Ah, I see it. I've just uploaded some sample screen dumps into
2_AssistanceNeeded. Report View is even weirder with 2pt borders. The thick
border appears around both subreports with a thin border separating them, and
bogus horizontal scroll bars show up!

I think I'll report it.

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:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Gaps between sub-reports when Border is larger than
hairline (Access 2007)

2007 (I put it in the subject, but it got clipped)

Imagine I have rptMain, rptSub1, and rptSub2. The subs are in the main report.

rptSub1.top=0, .left=0, .width=4, .height=1.0, .cangrow=yes, .canshrink=yes,
.borderstyle=solid, .borderwidth=2pt

rptSub2's properties are identical to rptSub1, but with it's top=1.0.

The rptSub2 moves appropriately as rptSub1 grows, but the gap between the two is
constant (unless I set the border width to hairline).

Setting rptSub2.top to anything other than 0.5, and the relative position
between the tow subs is lost.

Calvin

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@...>
wrote:
>
> 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> , "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]