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/
--------------------------------------------------------------------------- 4 5313
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/ --------------------------------------------------------------------------
-
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/ --------------------------------------------------------------------------
-
> "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/
---------------------------------------------------------------------------
"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/
--------------------------------------------------------------------------- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John Baker |
last post by:
Hi:
Stuck on another thing.
On a report I am creating, I want to make the detail section one line vertically. However,
in design view, I click on the page Footer Bar ,grab it with the "double...
|
by: Martin |
last post by:
Hi,
I have an Access 97 report that mimics an official UK Covernment
Customs document, with Page Headers and Footers presenting static data
for each page (logos etc). The report is made up...
|
by: Bill Short |
last post by:
I have a subreport in the detail section of the main report. The
subreport is set to CanGrow. I am using the Me.Line method (thanks to
Stephen Lebans) to create vertical lines that fill in...
|
by: terragrub |
last post by:
I found some code that works great to creat empty rows of boxes on a
report from the end of the data to the bottom of the report. Now, I
can't seem to find the original message to post a question...
|
by: jess |
last post by:
Hi,
Im using the following code to make a new report based on an existing
report.
Set rpt = CreateReport(, "_SemiAnnualMaster")
The problem that I am running into is that none of the report...
|
by: Greg |
last post by:
Most suggestions on this topic recommend to use a page footer and make
it visible only on the last page. My problem is that the footer is half
of the height of a page which means the detail would...
|
by: NJonge01 |
last post by:
Hi,
I'd like to produce a report that basically looks like an excel printout.
Description:
Profile Print Report
Detail Section with 3 bordered text boxes
all text boxes are 'abutted'...
|
by: replyrpatil |
last post by:
What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in)
...
|
by: NJonge01 |
last post by:
Hi, I have a report that should conditionally show some objects on the Report Header. These are the lowest objects in that section and they're not always necessary depending on where I'm opening...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |