Can Grow "borders"?

[Tom Brown]

I have enabled the "Can Grow" feature on some columns in a report. I also
have the border set to "hairline" on each field.
The reason I have borders is so I have a vertical line between the data in
each field.

The problem arises when one (or more) columns has enough text to require it
to grow. The other fields in that record might not have enough text to
require them to grow and it does not give a nice appreance on the report. I
end up having insances where one of the fields takes three lines and has a
nice big border around it. Next to that large "grown" field, there is a
field with only one line and its box is much smaller. It does not look
good.

This is difficult to explain but what I would like to know is ..... Is there
a way to make ALL the boxes on one record grow if one of them is larger?
Or, is there a way to put vertical lines between the different columns.

TIA,

Tom

 

[Marshall Barton]

I have enabled the "Can Grow" feature on some columns in a report. I also
have the border set to "hairline" on each field.
The reason I have borders is so I have a vertical line between the data in
each field.

The problem arises when one (or more) columns has enough text to require it
to grow. The other fields in that record might not have enough text to
require them to grow and it does not give a nice appreance on the report. I
end up having insances where one of the fields takes three lines and has a
nice big border around it. Next to that large "grown" field, there is a
field with only one line and its box is much smaller. It does not look
good.

This is difficult to explain but what I would like to know is ..... Is there
a way to make ALL the boxes on one record grow if one of them is larger?
Or, is there a way to put vertical lines between the different columns.

No, each text box grows to meet its own needs.

The proper way to get a vertical line between columns is to
draw a vertical line, not try to munge borders. Use the the
Line method in the section's Print event (where its final
height is known):

Me.Line (Me.textboxA.Left, 0) - Step(0,30000)

Since the line will be clipped at the section boundaries,
you do not actually have to know the final height of the
section.

 

[Tom Brown]

Marshall,

Many thanks! That got me "almost" there. I had no idea about that Line
Method ... or even the Print Event. But, I have not been able to get the
line to draw on the right side of the final column. If there was a Right
argument, I would have been able to do it. But, there's not so I have no
clue. I tried to figure it out with the Online Help but had no luck.

Thanks again,

Tom

 

[Duane Hookom]

Add the control Left to the Width to find the Right.

--
Duane Hookom
MS Access MVP

Marshall,

Many thanks! That got me "almost" there. I had no idea about that Line
Method ... or even the Print Event. But, I have not been able to get the
line to draw on the right side of the final column. If there was a Right
argument, I would have been able to do it. But, there's not so I have no
clue. I tried to figure it out with the Online Help but had no luck.

Thanks again,

Tom

 

[Tom Brown]

Duane,

I knew it probably had something to do with adding a value to space out the
right side but I don't even know how to do what you suggest. Although I was
able to get Mashall's suggestion to work, I don't know what each argument is
for. I have not been able to figure it out from the online help.

Here is the argument I am using for the left side of this particular column.
The column width is 2.5417".

Me.Line (Me.Remarks.Left, 0)-Step(0, 30000)

Can you show me how it would work?

Thanks,

Tom

Add the control Left to the Width to find the Right.

 

[Marshall Barton]

Here's the expression:

Me.Line (Me.Remarks.Left + Me.Remarks.Width, 0)-Step(0,
30000)

 

[Tom Brown]

Thanks to all!

Tom

Here's the expression:

Me.Line (Me.Remarks.Left + Me.Remarks.Width, 0)-Step(0,
30000)
--
Marsh
MVP [MS Access]

I knew it probably had something to do with adding a value to space out
the
right side but I don't even know how to do what you suggest. Although I
was
able to get Mashall's suggestion to work, I don't know what each argument
is
for. I have not been able to figure it out from the online help.

Here is the argument I am using for the left side of this particular
column.
The column width is 2.5417".

Me.Line (Me.Remarks.Left, 0)-Step(0, 30000)


"Duane Hookom" wrote

 

[Tom Brown]

Oh, I forgot to ask one more quesiton that I am curious about.

When I have a column that "grows" to three lines and all the rest of the
columns (in a columnar report) are only one line of text, they show up on
the report on the first line ... across the top of the row although the row
is now three lines deep.

Is there an easy way to make the cells with just one line justify in the
center of the now three lines deep box?

Thanks again,

Tom

Here's the expression:

Me.Line (Me.Remarks.Left + Me.Remarks.Width, 0)-Step(0,
30000)
--
Marsh
MVP [MS Access]

I knew it probably had something to do with adding a value to space out
the
right side but I don't even know how to do what you suggest. Although I
was
able to get Mashall's suggestion to work, I don't know what each argument
is
for. I have not been able to figure it out from the online help.

Here is the argument I am using for the left side of this particular
column.
The column width is 2.5417".

Me.Line (Me.Remarks.Left, 0)-Step(0, 30000)


"Duane Hookom" wrote

 

[Marshall Barton]

Nothing simple within Access, but
http://www.lebans.com/verticaljustification.htm
might do it for you.