using a parameter in a heading

  • Thread starter Thread starter Lee Stafford via AccessMonster.com
  • Start date Start date
L

Lee Stafford via AccessMonster.com

I have the three different criteria that are passed to the report from an
unbound form. One of them asks the Month. If no month is put in, then it
will print all months. (I want it to do that.) However, if it doesn't
have a month put in, then I don't want the Report Header to display the
month name. If it does, then it will only display the first month. How
can I have it display something different when no data is input?

Thanks,

Lee S.
 
I have the three different criteria that are passed to the report from an
unbound form. One of them asks the Month. If no month is put in, then it
will print all months. (I want it to do that.) However, if it doesn't
have a month put in, then I don't want the Report Header to display the
month name. If it does, then it will only display the first month. How
can I have it display something different when no data is input?

Thanks,

Lee S.
Click to expand...

As control source of the text control in the report that is going to
display the parameter:
= IIf(IsNull(forms!FormName!ControlName), "All Months",
forms!formName!ControlName)

The form must remain open when the report is run.
 
Back
Top