[AccessD] OT: Report Generator in .Net

Stuart,

Well, I discovered quite by accident that if, say, two text boxes are
located side by side but separated by some white space that if you
select them both and pick Format | Align | Left, the rightmost text
box will go snug up against the leftmost text box. That is, they don't
line up with the left edge of the leftmost text box. That, of course,
happens with text boxes that are separated by vertical space, too.
Access doesn't allow two text boxes to overlap when the Align command
is used and they're already vertically or horizontally aligned.

Oh, sure, I can get one column, then, that has thick lines around the
text boxes while the rest of the columns have thin lines. My complaint
about Access' ability to create grids in reports (notwithstanding
Charlotte's aesthetic objections to their appearance) is that if one
of the text boxes can grow vertically to accommodate more text, only
that "cell" grows on that row. The rest of the text boxes stay their
original size. So this nice grid is busted up by a goofy looking row
with one box taller than the rest. I'm just floored that after this
much time, Access doesn't have a "grid" or a "table" control that
works like a table in Word so that one field can have lots of text,
making the height of all the cells in that row grow to match the
tallest one's height.

My alternate "grid" with a light gray background just offers a different look.

Steve Erbach

On Fri, 25 Feb 2005 08:24:22 +1000, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> On 24 Feb 2005 at 7:39, Steve Erbach wrote:
> 
> > Charlotte,
> >
> > All right, then. I thought I'd mentioned that I was looking for a grid
> > on my reports. I've actually come up with a way to do it without
> > having to write any code. I set the background color of the report to
> > gray and then I make all the text boxes with a white background and
> > size and position them so that they're almost touching each other.
> > Voilà! A grid.
> >
> 
> It's much easier to set a small GridX and GridY and set SnapToGrid on so
> that all your text boxes actually touch each other. Then just set the
> border style, colour and width of the textboxes to give you exactly the
> grid you want without needing to worry about carefully locating every
> control with just the right spacing.
> 
> --
> Stuart
>