Re: Highligting criteria matches in a report. -- Conditional Forma

Tech-Archive recommends: Fix windows errors by optimizing your registry

This may just be over my head...
My conditional now reads
[Content] Like "*" & Forms!Content_Results!Content & "*"

Still dosen't highlight the word inside the memo field... ed "dues" .
here are the "control's" properties.

DATA TAB:
Control Source ............ Content
Input Mask ..................
Running Sum .............. NO
Smart Tags ................


OTHER TAB:
NAME .......Content
Vertical ..... no
Tag ..........

Valuing and appreciating your patience,

Rich



"strive4peace" <"strive4peace2006 at yaho" wrote:

Hi Rich,

you need to substitute the Name property of the control on
your Content_Results form for Controlname

--> Forms!Content_Results!YOURControlname

also, you need to SAVE the Content_Results form before you
open the report...in the code behind the Content_Results
form, try this...

if me.dirty then me.dirty = false


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Webmerlin57 wrote:
Followed your instructions exactly on the report, still can't get it to
highlight. (sigh)
I am searching through "memo" fields for the match, wondering if it can't
highlight the word inside the memo field.

here's what I'm using.
[Content] Like "*" & Forms!Content_Results!Controlname & "*"
Name is Content, Report name is Content_Results...

Thank you in adavance for all your help.

Rich


"strive4peace" <"strive4peace2006 at yaho" wrote:


Hi,

go to the design view of your report

click on the control you want to affect

from the menu --> Format, Conditional Formatting

choose --> expression is

then type in this equation -->

Like "*" & Forms!Formname!Controlname & "*"

where

Formname is the name of your form

Controlname is the NAME property of that control on the form
-->
use the properties window from the design view of your form
-- if the Name is ambiguous, like text345, thange it to make
sense. Don't use spaces or special characters except underscore


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Webmerlin57 wrote:

Newbie here,
I have a table called "content", a query called "content Query" and a report
called "content Matched"...

I understand that the conditional formmating is done in the report, but I'm
not sure of what goes where in the expression. Could I trouble you to
elaborate using my tables, forms, and reports?

Thank you in advance.

"strive4peace" <"strive4peace2006 at yaho" wrote:



use Conditional Formatting


from the menu --> Format, Conditional Formatting

expression is -->
[controlname] Like "*" & Forms!Formname!Controlname & "*"

then set the backcolor to yellow if the condition is met

make sure you SAVE Formname before opening report so
whatever the latest thing you changed it to is used

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Webmerlin57 wrote:


Nebwbie here. Please bear with me.

I run a report based on a word match query in a memo field. What I'm
wondering is can I highlight or color the matched criteria.

example:

searching for the word "dues" produces a result of:

"All members must pay their dues by December 31 of each year."

can I highligh (say yellow background with black forground) the word "dues"
in the report?

If so, could you explain how.

Thank you in advance.



.

Relevant Pages

  • Re: Highligting criteria matches in a report. -- Conditional Forma
    ... you need to substitute the Name property of the control on your Content_Results form for Controlname ... I am searching through "memo" fields for the match, wondering if it can't highlight the word inside the memo field. ... Name is Content, Report name is Content_Results... ... "All members must pay their dues by December 31 of each year." ...
    (microsoft.public.access.reports)
  • Re: Highligting criteria matches in a report. -- Conditional Forma
    ... I am searching through "memo" fields for the match, ... highlight the word inside the memo field. ... Name is Content, Report name is Content_Results... ... Conditional Formatting ...
    (microsoft.public.access.reports)
  • Re: Highligting criteria matches in a report. -- save form first
    ... Still dosen't highlight the word inside the memo field... ... you need to substitute the Name property of the control on your Content_Results form for Controlname ... Name is Content, Report name is Content_Results... ... searching for the word "dues" produces a result of: ...
    (microsoft.public.access.reports)
  • Re: Highligting criteria matches in a report. -- Conditional Formatting
    ... Conditional Formatting ... I run a report based on a word match query in a memo field. ... What I'm wondering is can I highlight or color the matched criteria. ... "All members must pay their dues by December 31 of each year." ...
    (microsoft.public.access.reports)
  • RE: highlight user input paramter
    ... I do have a color printer. ... There will not be a lot of text to highlight. ... the screen when I run the report, and then print the report with the ... I run a report to search Main Description for a user input ...
    (microsoft.public.access.gettingstarted)