Text Box Value

  • Thread starter Thread starter Amy Johnson
  • Start date Start date
A

Amy Johnson

I have a report that is based on a parameter query. The
parameter prompts for yes or no input. I have what is
selected appear on the report in a text box. If the
parameter is left blank it will pull up both yes and no
results. If the parameter is left blank however the text
box on the report is blank. Is there a way to have "both"
or some way to indicated that both yes and no are
selected to show up in the text box if the parameter is
left blank?
 
Amy said:
I have a report that is based on a parameter query. The
parameter prompts for yes or no input. I have what is
selected appear on the report in a text box. If the
parameter is left blank it will pull up both yes and no
results. If the parameter is left blank however the text
box on the report is blank. Is there a way to have "both"
or some way to indicated that both yes and no are
selected to show up in the text box if the parameter is
left blank?
Click to expand...


Try an expression like this:

=IIf([Yes-No] Is Null,"Both",[Yes-No])
 
Thank You so Much!!!!
-----Original Message-----
Amy said:
I have a report that is based on a parameter query. The
parameter prompts for yes or no input. I have what is
selected appear on the report in a text box. If the
parameter is left blank it will pull up both yes and no
results. If the parameter is left blank however the text
box on the report is blank. Is there a way to have "both"
or some way to indicated that both yes and no are
selected to show up in the text box if the parameter is
left blank?
Click to expand...


Try an expression like this:

=IIf([Yes-No] Is Null,"Both",[Yes-No])
Click to expand...
 
I have a report that is based on a parameter query. The
parameter prompts for yes or no input. I have what is
selected appear on the report in a text box. If the
parameter is left blank it will pull up both yes and no
results. If the parameter is left blank however the text
box on the report is blank. Is there a way to have "both"
or some way to indicated that both yes and no are
selected to show up in the text box if the parameter is
left blank?
Click to expand...

Try something like this, changing the expression to match the
parameters you are using.

In an unbound control in the report header:
=IIf(IsNull([Enter Yes or No]),"Yes and No",[Enter Yes or No])

The text inside the brackets above must be identical to the bracketed
parameter in the query.
 
Back
Top