If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
highlight user input paramter
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? |
#2
|
|||
|
|||
highlight user input paramter
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" wrote: 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? |
#3
|
|||
|
|||
highlight user input paramter
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? "Dorian" wrote: 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" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|