Prev: IFF Between...And
Next: Option group doesn't become visible
From: Eric on 8 Jul 2008 13:24
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?
From: Marshall Barton on 8 Jul 2008 14:05
Eric wrote:

>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

--
Marsh
MVP [MS Access]
From: Eric on 9 Jul 2008 12:22
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.


"Marshall Barton" wrote:

> Eric wrote:
>
> >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
>
> --
> Marsh
> MVP [MS Access]
>
From: Duane Hookom on 9 Jul 2008 12:42
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.

--
Duane Hookom
Microsoft Access MVP


"Eric" wrote:

> 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.
>
>
> "Marshall Barton" wrote:
>
> > Eric wrote:
> >
> > >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
> >
> > --
> > Marsh
> > MVP [MS Access]
> >
From: Marshall Barton on 9 Jul 2008 13:22
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.
--
Marsh
MVP [MS Access]


Eric wrote:

>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.
>
>
>"Marshall Barton" wrote:
>
>> Eric wrote:
>>
>> >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
 | 
Pages: 1
Prev: IFF Between...And
Next: Option group doesn't become visible