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

Hello David and Robert,

Thank you for continuing to work with me.

<<Easiest first:  bound simply means the text box is getting its contents from 
a field in the record being printed.>>

I understand.


<<As for the boxes overlapping:...>>

In my test report, I have only one line in the detail portion of the report. 
There is nothing to overlap

I am attempting to follow Robert's suggestion of combining both of your ideas. 
Now the only field in the detail section of my test report is the following 
expression:

   =Trim([PEOPLE]![PHONE] & [PEOPLE]![2nd_Phone])

When I run the test report, a small window named "Enter Parameter Value" 
opens, and "PEOPLE" is shown above the input window. It doesn't matter whether 
I enter nothing or such values as "all" in the input window. The result is a 
55-page report that contains only "#Error" on every other line. The alternate 
lines are blank.

As an experiment testing the concept of concatenation, I replaced the 
expression above with the following:

 =Trim("A"&"B")

This also gave me a 55-page report. It alternates lines containing "AB" and 
blank lines.

Please tell me what's wrong with the expression:

   =Trim([PEOPLE]![PHONE] & [PEOPLE]![2nd_Phone])

Please also tell me what parameter value is being requested.

Thanks again.

Ray Shapp


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