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

Hi Ray
 
As far as I know, "Enter Parameter Value" appears when your report is looking 
for a Field name to read from that it can't find - if I'm right, then obviously 
"toothcomb" check for spelling, but one particular idiosyncrasy that I have 
found is that you can't have any spaces in the Field name, replace with 
underscores is the usual method I adopt.
 
Good luck
Graham
________________________________

From: mso-bounce@xxxxxxxxxxxxx on behalf of Ray Shapp
Sent: Thu 13/12/2007 17:38
To: mso@xxxxxxxxxxxxx
Subject: [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
*************************************************************



-- No attachments (even text) are allowed --
-- Type: application/ms-tnef
-- File: winmail.dat


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