[mso] Re: Access Report
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 11 Jun 2003 14:04:42 -0400
/g
There might be a couple ways to do what you need. I haven't tried these
examples but they might help.
In each report section, header, detail, footer ect... you can count, using VBA,
the number of lines being used. If a section exceeds a certain number the you
can then shift the content around. This is difficult and I have never really
used this, but it can be done.
What might be a better option is to include some labels in each section of the
report. Size them to the size you need and where your report prints nicely,
then set the visible property to false. This way you can have the report layout
be defined by the invisible labels. Kind of like an invisible image on a web
page.
-Anthony
-----Original Message-----
From: Glenda Wells [ mailto:gwells@xxxxxxxxxxx]
Sent: Wednesday, June 11, 2003 9:17 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access Report
Hi All.
With the help of this list, I've made a pretty handy database that helps
us produce letters from data in linked ODBC tables. The process has
gone from about 3 hours a day to less than 30 minutes a day. I'm still
using macros instead of modules and I'm not using Pass Thru queries
where I could but I want to and will as time permits.
A source of frustration in this process has been the end-users and their
demands for cosmetic enhancements. I won't go into detail here but they
have made some rather, what I believe are, spurious demands. Be that as
it may, I gotta do it...graciously.
So, here's my question.
How can I center the information on a report both horizontally and
vertically. Actually, I got horizontally OK but can't seem to swing the
vertical. There are several headers and footers on a page. Some of the
data is hard-coded, the body of the letters for example.
Any advice appreciated. Thanks. /g
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
