Two Column Report

[Steve]

To make it simple, say the main report is Make and the subreport is model.
The subreport is set as a two column report, across then down. This works as
intended. However, each model is shown in its own box irrespective of if the
border of the text box is set as solid or transparent. I need both models in
a row to show only in one box that spans the width of both columns. And if
there is only one model in a row, I need that model to show in a box that
spans the width of both columns. Can this be done?

Thanks,

Steve

 

[Marshall Barton]

To make it simple, say the main report is Make and the subreport is model.
The subreport is set as a two column report, across then down. This works as
intended. However, each model is shown in its own box irrespective of if the
border of the text box is set as solid or transparent. I need both models in
a row to show only in one box that spans the width of both columns. And if
there is only one model in a row, I need that model to show in a box that
spans the width of both columns. Can this be done?

To have lines/boxes that go outside a section, you need to
use the Line method in the Page event.

How you would preserve the position of each "row" on the
page can be a pretty complex bunch of code, especially since
the "rows" are in a subreport and the main report has the
page event. (I think you will need to somehow make use of
the Me.Top property in the subreport detail Print event).

 

[Steve]

Marshall,

Thank you for the quick response!

The basic underlying question is how to create a two column report where the
model textbox does not appear with a solid border. This can be done by
checking "Print The Data Only" but then there is no box at all. From what I
have tried, if "Print The Data Only" is checked, any attempt to create a
line, box or whatever does not appear.

Can you give me an example of the Line method.

What do you mean by "preserve the position of each "row" on the page"?

Please explain what the Me.Top property is and how you think it should be
used.

Thank you,

Steve

 

[Steve]

Marshall,

I just read Help for the Top property and it seems this property only
applies to command bars.

Steve

Marshall,

Thank you for the quick response!

The basic underlying question is how to create a two column report where
the model textbox does not appear with a solid border. This can be done by
checking "Print The Data Only" but then there is no box at all. From what
I have tried, if "Print The Data Only" is checked, any attempt to create a
line, box or whatever does not appear.

Can you give me an example of the Line method.

What do you mean by "preserve the position of each "row" on the page"?

Please explain what the Me.Top property is and how you think it should be
used.

Thank you,

Steve

 

[Marshall Barton]

I just read Help for the Top property and it seems this property only
applies to command bars.

You need to look up this kind of stuff in the VBA Help file.
The Access Help file generally only deals with the point and
click stuff.

A report's Top property provides the section's top position
on the printed page.

Your questions imply that my comments are too advanced and
may not even address your problem so I think we should try
something else altogether.

Try setting the main report's subreport control's various
Border properties to see if you can get an acceptable
result. I don't see how this does what I thought your
original question asked, but I probably misinterpreted that
too.

 

[Keith Wilby]

To make it simple, say the main report is Make and the subreport is model.
The subreport is set as a two column report, across then down. This works
as intended. However, each model is shown in its own box irrespective of
if the border of the text box is set as solid or transparent. I need both
models in a row to show only in one box that spans the width of both
columns. And if there is only one model in a row, I need that model to
show in a box that spans the width of both columns. Can this be done?

Yes it can. What you need to do is contact a "resource" in MS Access. The
fee would be quite reasonable, some say even modest. I have a solution for
you if you want it. You can pay me via PayPal.

 

[Bob Quintal]

"Steve" <[email protected]>
wrote in message


Yes it can. What you need to do is contact a "resource" in MS
Access. The fee would be quite reasonable, some say even modest.
I have a solution for you if you want it. You can pay me via
PayPal.

Keith,

you should not stoop to his level. However, I hope Steve gets the
message.

 

[Keith Wilby]

you should not stoop to his level. However, I hope Steve gets the
message.

No I know Bob but sometimes my meter goes off the scale. I don't think he
will *ever* get the message. I think it's extremely generous of Marshall to
respond positively.