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

Not sure about suppressing a second line, but another possibility ...

IIRC, Access report fields have an "auto grow" option.  If you consolidate 
the phone numbers into a single field and then put auto grow on to it, it 
might give you the results you're looking for.

You might also be able to use this to narrow down some of your columns and 
increase your point size.  (After all, 8 point ain't much use to those of us 
with aging eyes.)  Basically, make the columns the right width to hold most 
people's information, and let people with longer information wrap 
vertically.  This is particularly useful for names and addresses, but can 
also be useful for items like skills lists.

Regards, Dave S

----- Original Message ----- 
From: "Ray Shapp" <ras45@xxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Wednesday, December 12, 2007 1:22 PM
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: