Can Grow "borders"?

  • Thread starter Thread starter Tom Brown
  • Start date Start date
T

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
 
Tom said:
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.
Click to expand...


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.
 
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
 
Add the control Left to the Width to find the Right.

--
Duane Hookom
MS Access MVP


Tom Brown said:
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
Click to expand...
 
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




Duane Hookom said:
Add the control Left to the Width to find the Right.
Click to expand...
 
Here's the expression:

Me.Line (Me.Remarks.Left + Me.Remarks.Width, 0)-Step(0,
30000)
 
Thanks to all!

Tom

Marshall Barton said:
Here's the expression:

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


Tom said:
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
Click to expand...
Click to expand...
 
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



Marshall Barton said:
Here's the expression:

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


Tom said:
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
Click to expand...
Click to expand...
 
Back
Top