Report Detail - How do I either anchor Lines or box


E

Eric

My task is to make each record in the detailed section of my report
"Contained" within a box.

I've tried may avenues (grouping, individual lines) but can't seem to get
either to grow or shrink as each record expands. How can you do this?

The detailed section contains individual apartment complexes that show
(subreport) all Unit Types (can grow to 25 types) with Rent/Sqft/etc. and
also include Amenities (a concatenated 1:M sql statement).

Any suggestions on how to outline the whole detailed section?
 
Ad

Advertisements

M

Marshall Barton

Eric said:
My task is to make each record in the detailed section of my report
"Contained" within a box.

I've tried may avenues (grouping, individual lines) but can't seem to get
either to grow or shrink as each record expands. How can you do this?

The detailed section contains individual apartment complexes that show
(subreport) all Unit Types (can grow to 25 types) with Rent/Sqft/etc. and
also include Amenities (a concatenated 1:M sql statement).


Use the Line method in the section's Print event procedure:

Me.Line (0,0)-(Me.Width,Me.Height), , B
 
E

Eric

Thanks - tried this but for some reason in Access 2003 this feature didn't
work. I tried setting the line.height = me.height as part of the Detail
Format procedure and kept getting the line to be the same size, wether or not
the detail record was equal to 1/3 the page or the whole page.

Tried placing it in other portions of code (detail print) and access barked
stating I couldn't set property when printing began.

another suggestions or what did I do wrong.
 
D

Duane Hookom

Marsh expected you to use the Line method, not a line control. You can grab
the "Grown Height" of a control in the On Print event. The On Print event is
too late to set the height of another control.
 
Ad

Advertisements

M

Marshall Barton

You can not use a Line control. You must use the VBA
statement in the detail section's Print event procedure.

Since you don't seem to understand the difference between
code in an event procedure and a control on the report,
follow these steps:

Doubleclick on the little gray bar at the top of the detail
section.

Select the Event tab at the top of the property sheet and
look down the list of event properties and click on the On
Print property.

Click on the dropdown arrow on the right side of the
property and select [Event Procedure]

Click on the builder button (with three dots) in the
property's right margin.

You should then see the Print event procedure. Copy/Paste
the statement I posted between the Sub and End Sub lines.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top