Printing Filter on report

[jcarmody]

Hello:

Through this forum I found a slick way to include a date picker as an on open event for my reports to allow the user to choose a starting and ending date range. Works slick, thank you. In the report header I print the filter to alert the users that the report has filtered data.

=IIf(Report.Filter<>"","Filtered to show: " & Report.Filter)

My report.Filter looks something like this:
Date Between #2/1/08# and #2/18/08#

Is there a way to leave the # in the filter but not print them in my report header.

It doesn't bother me, but I know I'll get questions.

Thanks -

JC

 

[ck1999]

Replace (rpt.filter, "#", "")

 

[jcarmody]

OK, now you're going to find out how little I know. Where do I put this?

 

[ck1999]

Try this
=IIf(Report.Filter<>"","Filtered to show: " & Replace (rpt.filter, "#", ""))

If this does not work use vba
probrably in the report_load

dim vfilter

vfilter = Replace (rpt.filter, "#", "")
txtboxfilter =IIf(Report.Filter<>"","Filtered to show: " & vfilter)

txtboxfilter is whatever txtbox in your header

ck1999

 

[jcarmody]

Thank you!!! Your first suggestion worked like a charm.