Hi!
OK, I am writing a book, based on a large database with the key fields being named "what" and "how".
Because I had the need every so often to quickly find all instances of any (particular) word within the database, without going to the bother of thinking about where that word/subject might be in the data base, I designed a report which does the job nicely.
It uses a search form/control, searches and finds all instances of the word (or words) I have asked it to find, then does a report showing all instances of whatever RTF memo fields that contain the word(s).
It has to be RTF memo field because (if I wish) it goes straight into the book text I'm writing, and also it searches the book's RTF memo field.
.
The trouble is, at present, I then have to manually "eye scan" the resulting report to find the occurrences of the "key searched for" word, nestling/hidden somewhere within sometimes quite large chunks of text.
I would love to have the report show the found "key word(s)" highlighted in (say) light blue or whatever colour, so that I can quickly & easily lock on to it visually.
I'm not very Access savvy but here goes with some particular info ---
I enter the word I want Access to find, into a form called "formfindword" in a text box called Text0. I click on a command box on this form, to open up the report called "Querywhatsandhowschooseword" based on a query of the same name.
The query's "what" field (from the main database) has the criteria
= Like "*" and [forms]![Formfindword]![Text0] & "*"
The query's "how" field criteria (in the "or" line of the query design) is also
= Like "*" & [forms]![Formfindword]![Text0] & "*"
I have tried to use the Conditional Format facility in Report Layout view, without any luck.
I think therefore that I will need some VBA code (which is totally foreign to me, unfortunately) to make this simple concept a reality.
Given the above, can somebody put their minds to the problem and come up with an answer that has some hope of being implemented into my report, however that is to be done ....?
Hope you can follow the detail OK.
I am using MS Access 2007, by the way. And my apologies if this has been covered somewhere else in the forum, I couldn't find it.
EdK
OK, I am writing a book, based on a large database with the key fields being named "what" and "how".
Because I had the need every so often to quickly find all instances of any (particular) word within the database, without going to the bother of thinking about where that word/subject might be in the data base, I designed a report which does the job nicely.
It uses a search form/control, searches and finds all instances of the word (or words) I have asked it to find, then does a report showing all instances of whatever RTF memo fields that contain the word(s).
It has to be RTF memo field because (if I wish) it goes straight into the book text I'm writing, and also it searches the book's RTF memo field.
.
The trouble is, at present, I then have to manually "eye scan" the resulting report to find the occurrences of the "key searched for" word, nestling/hidden somewhere within sometimes quite large chunks of text.
I would love to have the report show the found "key word(s)" highlighted in (say) light blue or whatever colour, so that I can quickly & easily lock on to it visually.
I'm not very Access savvy but here goes with some particular info ---
I enter the word I want Access to find, into a form called "formfindword" in a text box called Text0. I click on a command box on this form, to open up the report called "Querywhatsandhowschooseword" based on a query of the same name.
The query's "what" field (from the main database) has the criteria
= Like "*" and [forms]![Formfindword]![Text0] & "*"
The query's "how" field criteria (in the "or" line of the query design) is also
= Like "*" & [forms]![Formfindword]![Text0] & "*"
I have tried to use the Conditional Format facility in Report Layout view, without any luck.
I think therefore that I will need some VBA code (which is totally foreign to me, unfortunately) to make this simple concept a reality.
Given the above, can somebody put their minds to the problem and come up with an answer that has some hope of being implemented into my report, however that is to be done ....?
Hope you can follow the detail OK.
I am using MS Access 2007, by the way. And my apologies if this has been covered somewhere else in the forum, I couldn't find it.
EdK
