By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,530 Members | 2,181 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,530 IT Pros & Developers. It's quick & easy.

[Report] Change Section Height

P: n/a
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>Section.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/
---------------------------------------------------------------------------
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


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

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
' Change the height here
Me.Detail.Height = ' value
End Sub
Darryl Kerkeslager

"ALESSANDRO Baraldi" <ik****@libero.it> wrote in message
news:cj**********@lacerta.tiscalinet.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>Section.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/
-------------------------------------------------------------------------- -

Nov 13 '05 #2

P: n/a
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.tiscalinet.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>Section.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/
-------------------------------------------------------------------------- -

Nov 13 '05 #3

P: n/a
> "ALESSANDRO Baraldi" <ik****@libero.it> wrote in message
news:cj**********@lacerta.tiscalinet.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>Section.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*********@comcast.net> ha scritto nel messaggio
news:SI********************@comcast.com... Every report section has a Format property. Click in detail, and create a
format event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
' Change the height here
Me.Detail.Height = ' 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/
---------------------------------------------------------------------------
Nov 13 '05 #4

P: n/a
"Larry Linson" <bo*****@localhost.not> ha scritto nel messaggio
news:ugK5d.1717$ku4.1650@trnddc01...
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/
---------------------------------------------------------------------------
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.