473,397 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Use VBA to set length of the Details section of a report

Is it possible to set the height of the details section of a report using
VBA? I watt to put a value into a table for the height of the report
section, so it can be altered by a user.

dixie
Nov 12 '05 #1
2 1739
You can with A2K or higher. Set the desired height within the Section's
Format event.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"dixie" <di****@dogmail.com> wrote in message
news:gP*****************@nnrp1.ozemail.com.au...
Is it possible to set the height of the details section of a report using VBA? I watt to put a value into a table for the height of the report
section, so it can be altered by a user.

dixie


Nov 12 '05 #2
Me.Detail.Height = 1 * 1440 will set it to 1-inch

note.. you cannot reduce it than the amount of space required for all
the controls in the 'detail' section
"dixie" <di****@dogmail.com> wrote in message news:<gP*****************@nnrp1.ozemail.com.au>...
Is it possible to set the height of the details section of a report using
VBA? I watt to put a value into a table for the height of the report
section, so it can be altered by a user.

dixie

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Sherwood Botsford | last post by:
I'm new to access. I have an orienteering database that has information about locations all over the map. Each location has 0-N clues I've worked up a report that will print the locations,...
3
by: Melissa | last post by:
What specifically causes the Format event of a report's section to fire? Thanks! Melissa
6
by: Steve Jorgensen | last post by:
I tried to fix a problem for a client today in which report sections and even individual text controls in some of their reports are being split across page boundaries. Of course, I was thinking...
3
by: lorirobn | last post by:
Hello, I'm creating a one-page report that will display only total counts, no details. I want to examine the values of 2 fields on the source table, and add to appropriate counters accordingly....
2
by: Mike Abbott | last post by:
A fairly recent convert to Access I have succeeded in getting it to work well on my current fairly simple requirements. Can someone help me with another step? I have three simple reports. ...
1
by: John | last post by:
Hi I am doing a report to print invoices on pre-printed laser invoice forms. The invoices can go on more than one page potentially depending on the amount of details. On my report the detail...
0
by: marcellus7 | last post by:
Hows it going everyone. Im pretty new to Crystal Reports, and am in the process of trying to setup my first Crystal Report in my windows app. I am loading data from a DataSet, and am finally getting...
0
lotus18
by: lotus18 | last post by:
Hello World! I have reports (receipts, invoices, etc) created in crystal report and they are working fine, but my client has a pre-printed reports and he wants all the details of the report to...
1
by: AccessInCA | last post by:
I have a report that is grouped by a field called DataSource. In the detail section of the report where the record data fields are displayed, such as Jan, Feb, Mar, etc, I want to format the decimal...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.