displaying search paramater on report

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

My query has the following in the criteria box of a memo field.

Like "*" & [Text To Find] & "*"

I would like the search text that is entered in the paramater box to display
in the report header.

How would I accomplish this? Thanks!
 
My query has the following in the criteria box of a memo field.

Like "*" & [Text To Find] & "*"

I would like the search text that is entered in the paramater box to display
in the report header.

How would I accomplish this? Thanks!
Click to expand...

Use an unbound control in the report header.
Set it's control source to:
="Looking for records that contain the words " & [Text To Find]

The text within the brackets must be identical to the bracketed text
in the query.
 
Back
Top