[mso] Re: Access 2003: How to Conditionally Print A LIne In A Report?

Ray,

To prevent Access from printing this blank line when there is no value ,
you need to set the "Can Shrink" property on that field to "Yes.
When you run your report, the blank line should no longer appear when
the field does not contain a value.

Important: The only caution when using the "Can Shrink" property is to
make sure that the field that you are shrinking does not overlap with
any other field (either a physical overlap or another field that has the
same "Top/Height" range). If there is an overlap, Access will not shrink
the field as desired. Basically it should be the only thing on that
line.


Robert Tillotson
BAE-IT
Groton Field Office
860-441-2207

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Ray Shapp
Sent: Tuesday, December 11, 2007 9:22 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access 2003: How to Conditionally Print A LIne In A
Report?

To All,

How can I cause certain lines in a report to display and print depending
on a given criterion?

In an Access 2003 database, I currently print a roster of all active
members of a club. In landscape mode, all desired fields just barely fit
across the page using font size 8 points. Today, I have added a new
field to the DB in which to record an alternative phone number (cell,
work, etc.). Now I want the roster to display and print a second line
only for those members who have non-blank 2nd phone info recorded. The
full roster was printing on fifty-five
8.5 x 11-inch pages. When I added the line showing second phone, the
roster now consumes 110 pages even though fewer than ten percent of
members have listed a second phone with us.

Please tell me how to suppress the second line for those members who
have no info in the 2nd phone field.

Ray Shapp
Access 2003
WinXP Pro SP2


*************************************************************
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, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: