Highlight one value on a continuous form

[John Baker]

I have a continuous form with a number of text boxes of bound fields. I
would like to be able to highlight certain values when they appear in the
text box. For example when a "P" appears in one of the fields I would like
the value to be bold. I have tried using an if statement to change the
textbox format, but of course this will change all values for that textbox
in this field's column to also be bold. Is there anyway to just highlight
the one value in a column of values on a continuous form?


Any help greatly appreciated.

John Baker
(e-mail address removed)

 

[Sandra Daigle]

If you are using Access 2000 or above you can use Conditional Formatting
(CF). To use, select the control, click Format, Conditional Formatting.
Check the help for more details.

CF is somewhat limited in what it can do but it is useful for many
situations. Stephen Lebans has put together a sample database demonstrating
some ways to use Conditional Formatting:
http://www.lebans.com/conditionalformatting.htm

For a more robust solution Stephen Lebans also has code that provides more
conditional formatting features for forms - this also works in Access97:
http://www.lebans.com/formatbycriteria.htm