showing All

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has a textbox on that is used to show the acct type that
was selected. Recently, the svp asked to have it so all accts will show
rather then the selected type. Changing the parameter is not the issue.
What is, is the text box on the report that shows the acct type. As of now
the following line is in the control source of the textbox on the report.

=[Forms]![usrfrmReportModule]![cboAccountType]

What I would like to do is to show "All" in the textbox if no one selects
the acct type. How would the above line be modified? I am at a loss on
this.
Thanks in advance to anyone responding to this.
*** John
 
JohnE said:
I have a report that has a textbox on that is used to show the acct type that
was selected. Recently, the svp asked to have it so all accts will show
rather then the selected type. Changing the parameter is not the issue.
What is, is the text box on the report that shows the acct type. As of now
the following line is in the control source of the textbox on the report.

=[Forms]![usrfrmReportModule]![cboAccountType]

What I would like to do is to show "All" in the textbox if no one selects
the acct type. How would the above line be modified?
Click to expand...


Maybe this will do that:

=IIf(IsNull([Forms]![usrfrmReportModule]![cboAccountType]),
"ALL", [Forms]![usrfrmReportModule]![cboAccountType])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't use more than one duplicate 4
Calculate variance in group footer 3
textbox info based on cbo 1
More Subtotals in a Report 3
sum of all numbers 6
Transpose data in a report-Field values broken down to separate co 9
Getting data in a report from a second table? 1
#error 1

Back
Top