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

To All,

Here's a message I received privately from James.LaBorde. See it below.

The key info (which I may have missed in earlier messages) is that the "Can 
Shrink" property must be set for the entire Detail section  --  not just for 
the text box. The report is now only 30 pages long and it has no blank lines.

My original problem is fully solved!!!

Many thanks to everyone for staying with me.

The 2nd_Phone field is a new addition to the DB. Only a few records have any 
entry in that field and no contents of that field have ever been edited or 
deleted. Nevertheless, I would like to ensure that the 2nd_Phone field for 
each record contains either a valid phone number or a null value. The source 
of the report is not a query. It is the main table containing records for all 
members of our club. In order to incorporate James' idea, where do I insert 
the IFF expression?

Since this is a separate question, I will post it again in a new thread.

Ray Shapp


----- Original Message ----- 
From: "James LaBorde" <jlaborde@xxxxxxxxx>
To: "Ray Shapp" <ras45@xxxxxxxxxxxxx>
Sent: Thursday, December 13, 2007 1:47 PM
Subject: RE: [mso] Re: Access 2003: How to Conditionally Print A LIne In A 
Report?


> Ray,
>
> I am replying to you directly since MSO seems to have a problem with my 
> email getting to the group. If you reply, please reply back to the group so 
> others can see your solution/other problems.
>
> What you want to do to take advantage of the Can Shrink option, the field 
> needs to be null or zero length.  What I would guess is the problem on some 
> of yours is that someone deleted the data by entering a space for it.  To 
> eliminate this you can trap it in your query.  Instead of just incluing the 
> alternate phone do something along the lines of
>
> AltPhone: IIF([alternatephone] <> " ", [alternatephone])
>
> or
>
> AltPhone: IIF(len([alternatephone]) >6, [alternatephone])
>
> This way you will either get a valid alternate phone or a null value, then 
> if the alternate phone is the only thing on your second line, you should be 
> okay.  Just make sure you set both the Can Shrink property for both the 
> field in question AND for the detail section.  This should eliminate the 
> extra space for your all of those without the extra line.
>
> Thank You,
> James
>

*************************************************************
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: