highlight user input paramter

[jjhinton]

I have a text field in my database which can be quite lengthy named “Main
Descriptionâ€. I run a report to search Main Description for a user input
parameter. Let’s say I’m looking for the word “Snowdenâ€. Right now the
report will print every record that contains the word “Snowden†in the Main
Description.

I have 2 questions:

1) Can I make the user input word “Snowden†appear in red in the Main
Description field
in the report?

2) Sometimes the Main Description is 4 or 5 pages long, and the report is
very lengthy. Is there a way to only print the pages that the word “Snowdenâ€
appears on?

 

[Dorian]

The answers depend on what version of Accsss you are using.

(1) Will not be easy since the display attributes apply to a complete
control (this may be different in Access 2007). Do you have printers that
print in colour?

(2) Is possible but you will need to pre-process the text field to include
only the content you want. You'll need to decide how many characters before
and after the 'search word' you want to include and then write a function to
exclude the rest.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[jjhinton]

I am using Access 2002. I do have a color printer.

There will not be a lot of text to highlight. What I want to do is run a
query and ask the user for a parameter. This parameter is a keyword we are
searching for. then we display the records that contain that keyword.

Would it be possible to highlight the keyword which was input by the user on
the screen when I run the report, and then print the report with the
highlighted word?