How do I add conditional formatting to report with parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ginny - 29 Dec 2005 19:21 GMT

I have a report which is based on a query on a "description" memo field in
which I use a parameter to search the field for a keyword and return those
records which have the word in the description field.

When the records are returned in the report i would like the keyword I
entered in the paramater appear in the description field with conditional
formatting (RED FONT, BOLD).

Is there a way to do this?--
Ginny

Reply to this Message

Allen Browne - 30 Dec 2005 04:01 GMT

The text box in Access is not able to format some of the text differently
than other parts.

For alternatives, see:
http://www.lebans.com/mixbold-plain.htm
http://www.lebans.com/richtext.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a report which is based on a query on a "description" memo field in
> which I use a parameter to search the field for a keyword and return those
[quoted text clipped - 6 lines]
> Is there a way to do this?--
> Ginny

Reply to this Message