[Report] Change Section Height

[ALESSANDRO Baraldi]

Hi and Good Sunday.

Have i any way to Reduce at Runtime, with
no change on Design View, the Height property
of Detail_Section on my Report.....?

The Section Property is Read_Only but if
i encrease one Control inside with
ctl.Height>Sect ion.Height
automatically the Section adapt the Height
to englobe the control.....!
This is not a good way, but Work, only on Step_UP.

I look for any way to Step_Down the Section_Size
No trought DesigneTime.

Thanks

--
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------

[Darryl Kerkeslager]

Every report section has a Format property. Click in detail, and create a
format event:

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
' Change the height here
Me.Detail.Heigh t = ' value
End Sub
Darryl Kerkeslager

"ALESSANDRO Baraldi" <ik****@libero. it> wrote in message
news:cj******** **@lacerta.tisc alinet.it...

Hi and Good Sunday.

Have i any way to Reduce at Runtime, with
no change on Design View, the Height property
of Detail_Section on my Report.....?

The Section Property is Read_Only but if
i encrease one Control inside with
ctl.Height>Sect ion.Height
automatically the Section adapt the Height
to englobe the control.....!
This is not a good way, but Work, only on Step_UP.

I look for any way to Step_Down the Section_Size
No trought DesigneTime.

Thanks

--
@Alex (Alessandro Baraldi)
-------------------------------------------------------------------------- - http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
-------------------------------------------------------------------------- -

[Larry Linson]

My question would be, what are you trying to accomplish. If you simply want
to adjust for differing amounts of data in Text Boxes within the Section,
and there is no other control aligned alongside that Text Box, set the
CanShrink and CanGrow properties of the Text Box _and_ the Section to Yes.
That will automatically grow- or shrink-to-fit.

If there is some other reason for doing so, Darryl has correctly pointed out
that you can modify the Detail.Height property in the Format (and, I think,
also in the Print) event.

Larry Linson
Microsoft Access MVP


"ALESSANDRO Baraldi" <ik****@libero. it> wrote in message
news:cj******** **@lacerta.tisc alinet.it...

Hi and Good Sunday.

Have i any way to Reduce at Runtime, with
no change on Design View, the Height property
of Detail_Section on my Report.....?

The Section Property is Read_Only but if
i encrease one Control inside with
ctl.Height>Sect ion.Height
automatically the Section adapt the Height
to englobe the control.....!
This is not a good way, but Work, only on Step_UP.

I look for any way to Step_Down the Section_Size
No trought DesigneTime.

Thanks

--
@Alex (Alessandro Baraldi)
-------------------------------------------------------------------------- - http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
-------------------------------------------------------------------------- -

[ALESSANDRO Baraldi]

> "ALESSANDRO Baraldi" <ik****@libero. it> wrote in message

news:cj******** **@lacerta.tisc alinet.it...

Hi and Good Sunday.

Have i any way to Reduce at Runtime, with
no change on Design View, the Height property
of Detail_Section on my Report.....?

The Section Property is Read_Only but if
i encrease one Control inside with
ctl.Height>Sect ion.Height
automatically the Section adapt the Height
to englobe the control.....!
This is not a good way, but Work, only on Step_UP.

I look for any way to Step_Down the Section_Size
No trought DesigneTime.

Thanks

"Darryl Kerkeslager" <Ke*********@co mcast.net> ha scritto nel messaggio
news:SI******** ************@co mcast.com... Every report section has a Format property. Click in detail, and create a
format event:

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
' Change the height here
Me.Detail.Heigh t = ' value
End Sub
Darryl Kerkeslager

Hi Darryl.
Thanks for Replay.
I need to poit to Heigt property from an External Form
that i Use to properly format my Preview Control at Runtime.
So i check the Section Property of my Control and need
to Reduce it if too many space is inside it....!
I build an External Formatting_Form to give to the user
the capability of Full formatting Report.

I try to use your suggestion..... !

Bye
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------

[ALESSANDRO Baraldi]

"Larry Linson" <bo*****@localh ost.not> ha scritto nel messaggio
news:ugK5d.1717 $ku4.1650@trndd c01...

My question would be, what are you trying to accomplish. If you simply want to adjust for differing amounts of data in Text Boxes within the Section,
and there is no other control aligned alongside that Text Box, set the
CanShrink and CanGrow properties of the Text Box _and_ the Section to Yes.
That will automatically grow- or shrink-to-fit.

If there is some other reason for doing so, Darryl has correctly pointed out that you can modify the Detail.Height property in the Format (and, I think, also in the Print) event.

Larry Linson
Microsoft Access MVP

Thanks for Replay.
I build an External Reports Formatting_Form to give to the user
the capability of Full formatting Report.
Reguard your question my replay is Yes, i need only to Reduce
to the Min_Size the Section Height, so i think that your Suggestion
can be perfect.

I'll Try immediatly.

Thank
--
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------