Can Grow "borders"?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom Brown - 17 Jul 2005 18:09 GMT

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

Reply to this Message

Marshall Barton - 17 Jul 2005 19:37 GMT

>I have enabled the "Can Grow" feature on some columns in a report. I also
>have the border set to "hairline" on each field.
[quoted text clipped - 12 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Tom Brown - 18 Jul 2005 02:53 GMT

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

>>I have enabled the "Can Grow" feature on some columns in a report. I also
>>have the border set to "hairline" on each field.
[quoted text clipped - 28 lines]
> you do not actually have to know the final height of the
> section.

Reply to this Message

Duane Hookom - 18 Jul 2005 02:58 GMT

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

Signature

Duane Hookom
MS Access MVP

> Marshall,
>
[quoted text clipped - 42 lines]
>> you do not actually have to know the final height of the
>> section.

Reply to this Message

Tom Brown - 18 Jul 2005 03:14 GMT

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.
>
[quoted text clipped - 45 lines]
>>> you do not actually have to know the final height of the
>>> section.

Reply to this Message

Marshall Barton - 18 Jul 2005 03:34 GMT

Here's the expression:

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

Signature

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
[quoted text clipped - 50 lines]
>>>> you do not actually have to know the final height of the
>>>> section.

Reply to this Message

Tom Brown - 18 Jul 2005 03:43 GMT

Thanks to all!

Tom

> Here's the expression:
>
[quoted text clipped - 69 lines]
>>>>> you do not actually have to know the final height of the
>>>>> section.

Reply to this Message

Tom Brown - 18 Jul 2005 03:49 GMT

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:
>
[quoted text clipped - 69 lines]
>>>>> you do not actually have to know the final height of the
>>>>> section.

Reply to this Message

Marshall Barton - 18 Jul 2005 04:16 GMT

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

Signature

Marsh
MVP [MS Access]

>Oh, I forgot to ask one more quesiton that I am curious about.
>
[quoted text clipped - 80 lines]
>>>>>> you do not actually have to know the final height of the
>>>>>> section.

Reply to this Message

MrSnid - 13 May 2008 16:21 GMT

Thanks, this is exactly what I need to do... but am a novice when it comes to
adding code.

Can you give me this explaination below with some training wheels attached ?

Thanks
Mr Snid

>>I have enabled the "Can Grow" feature on some columns in a report. I also
>>have the border set to "hairline" on each field.
[quoted text clipped - 14 lines]
>you do not actually have to know the final height of the
>section.

Reply to this Message

Rate this thread: