Conditional Text Box

I have a report that in first place opens a form to enter=20
criterias for the source query.=20
I would like to show on the report title the criteria of=20
the search in case that there are somo of them.=20
For example if the user enter dates, then a text box will=20
appear on the tittle "From xx/xx/xx to xx/xx/xx" , but if=20
thre not filters selected, then don=B4t show the text box

Thank you very much

On Thu, 8 Jul 2004 13:54:10 -0700, Ana wrote:

I have a report that in first place opens a form to enter
criterias for the source query.
I would like to show on the report title the criteria of
the search in case that there are somo of them.
For example if the user enter dates, then a text box will
appear on the tittle "From xx/xx/xx to xx/xx/xx" , but if
thre not filters selected, then don´t show the text box

Thank you very much

In the Report Header add an unbound control.
Set it's control source to:
=IIf IsNull(forms!FormName!StartDate),"","From " &
Format(forms!FormName!StartDate,"mm/dd/yy") & " to " &
Format(forms!FormName!EndDate,"mm/dd/yy")

Change forms!formName!StartDate (and EndDate) to whatever the actual
name of the form and control names are.


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Thank you very very much


-----Original Message-----
On Thu, 8 Jul 2004 13:54:10 -0700, Ana wrote:

I have a report that in first place opens a form to=20
enter=20
criterias for the source query.=20
I would like to show on the report title the criteria=20
of=20
the search in case that there are somo of them.=20
For example if the user enter dates, then a text box=20
will=20
appear on the tittle "From xx/xx/xx to xx/xx/xx" , but=20
if=20
thre not filters selected, then don=B4t show the text box
=20
Thank you very much

In the Report Header add an unbound control.
Set it's control source to:
=3DIIf IsNull(forms!FormName!StartDate),"","From " &
Format(forms!FormName!StartDate,"mm/dd/yy") & " to " &
Format(forms!FormName!EndDate,"mm/dd/yy")

Change forms!formName!StartDate (and EndDate) to whatever=20
the actual
name of the form and control names are.


--=20
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.