Highlight text - Can not use conditional formatting.

[JKlein]

I am looking for a way to highlight certain records showing in a subform.
Something like this

If clientID = "377" then
clientid.forecolor = 255 else
clientid.forecolor = 0
endif

I have placed code like this in the subforms on current event...does not
work.
I am using Access 97 so I can not use the Conditional Formatting that newer
versions have.
Any ideas??

 

[Marshall Barton]

I am looking for a way to highlight certain records showing in a subform.
Something like this

If clientID = "377" then
clientid.forecolor = 255 else
clientid.forecolor = 0
endif

I have placed code like this in the subforms on current event...does not
work.
I am using Access 97 so I can not use the Conditional Formatting that newer
versions have.

That code looks logical to me. What don't you like about
its result?

Note that the result will not be what's desired in a
continuous or datasheet form.

Are you sure that Client ID is a text field? If not, remove
the quotes aroung the 377.

 

[JKlein]

I have a continuous form

That code looks logical to me. What don't you like about
its result?

Note that the result will not be what's desired in a
continuous or datasheet form.

Are you sure that Client ID is a text field? If not, remove
the quotes aroung the 377.

 

[Marshall Barton]

Without trying to be presumptuous, I assume you are trying
to deal with the fact that your code changes the colors on
all the rows. If so, then here's two articles that
demonstrate different techniques for getting the desired
effect:

http://www.mvps.org/access/forms/frm0024.htm
http://www.lebans.com/formatbycriteria.htm