Hi Rich,
try this:
before you run your report... you need to SAVE the form -- try File,
Save from the menu -- it WON'T work unless you save it... it should if
you do...
If you still have problems, attach your db and specify what to look at
Warm Regards,
Crystal
Microsoft Access MVP 2006
*
Have an awesome day
remote programming and training
strive4peace2006 at yahoo.com
*
Webmerlin57 wrote:
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
:
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
:
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.
:
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.
