[AccessD] Variable line height

Bobby Heid bheid at sc.rr.com
Wed Apr 22 21:00:21 CDT 2009


I once did something with some of the events at a former job, but I cannot
remember any of the details, sorry.  But I did want to state that it did
work pretty good.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Wednesday, April 22, 2009 9:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Variable line height

Rocky,

Well, you could print the report on a pre-printed form that has a line
down the middle!!  Just kidding!

I've done something similar with columnar reports to provide both
vertical and horizontal lines in a grid.  I CHEATED!

That is, I set the detail area background color to gray and then I
made sure that all the text boxes are wide and high enough to leave
just a smidgin of space between rows and columns.  The background
color then shows through in between text boxes and gives the effect of
grid lines.

Of course, if you've got text boxes that grow, then there will be
large areas of gray where one box isn't as tall as the one next to it.
 For what it's worth, I've never cared for the inability of Access to
make grids in the report designer.

Are you saying that there's just two side-by-side text boxes per page?
 Or might there be several pairs of boxes, one pair in each detail
row?

I'm temporizing...I've never run across anything that did what you
want in a simple fashion.  I suppose that there are Report events one
could rely on to change the height of a dividing line...but I'll bet
very few people use them.

Steve Erbach
Neenah, WI

On Wed, Apr 22, 2009 at 7:11 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> Dear List:
>
> Client has a report with two Can Grow text boxes side by side.  He wants a
> vertical line down the middle of the report separating the two boxes. The
> two text boxes will vary in height, of course, depending on the data. How
> can the height of the line be set to run vertically down the full length
of
> the detail section of the report where these two boxes are.  You can't
> change the height of the line in the Print event, and the height of the
box
> is apparently not yet set (per a MsgBox I inserted) in the Format event?
>
> MTIA
>
> Rocky







More information about the AccessD mailing list