displaying search paramater on report

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!
 
F

fredg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Paramater Entered for Report 4
How do I add conditional formatting to report with parameter 1
Choosing parameters from a list. 3
Parameter search in a text field 1
text box in report is truncating memo field at 255 characters 2
missing data 2
Need help working with sub reports and main report. 5
Parameter Query In Report Title 3

Top