[AccessD] Variable line height

Rocky Smolin rockysmolin at bchacc.com
Wed Apr 22 21:54:03 CDT 2009


“Are you saying that there's just two side-by-side text boxes per page?”
Yep.
“Are you saying that there's just two side-by-side text boxes per page?” Ne
neither.
“I suppose that there are Report events one could rely on “ Not that I know
of.  

Your solution would work if the two boxes were the same height.  But the one
on the right will always be shorter.
Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Wednesday, April 22, 2009 6: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...Are you saying that there's just two side-by-side text
boxes per page? 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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list