setting properties on a sub form

[Guest]

Access 97 question

I have a continuous subform. Multiple records with multiple fields for each
record all nicely retrieved from a query. I want to set the forecolor
property for each record to different colors depending upon the value in one
of the fields of that record.

My issue is WHERE would i put code like this:
me.priorioty.forecolor = iif(me.priority = "1/1/2002",0,255)

I want each record to color itself based on the value in the field

I keep thinking this should be easy, but i'm not having any luck.

Help ?

-Doug

 

[George Nicholson]

Once you change the forecolor of a control in a continuous control, the
forecolor of control will be changed in *all* visible records. That's simply
how continuous forms work.

It sounds like what you want is conditional formatting which supports
record-specific formatting. Unfortunately, conditional formatting wasn't
built into Access until Access 2000.

For a Access 97 solution:
http://www.mvps.org/access/forms/frm0024.htm
Forms: Colors and Continuous Forms.

HTH,

 

[Guest]

I appreciate the information. Thanks for the reply.

 

[Marshall Barton]

Access 97 question

I have a continuous subform. Multiple records with multiple fields for each
record all nicely retrieved from a query. I want to set the forecolor
property for each record to different colors depending upon the value in one
of the fields of that record.

My issue is WHERE would i put code like this:
me.priorioty.forecolor = iif(me.priority = "1/1/2002",0,255)

I want each record to color itself based on the value in the field

I keep thinking this should be easy, but i'm not having any luck.

Definitely not easy in A97. Take a look at these articles
to see if you want to, or even can, go to the trouble:

http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0047.htm
http://www.mvps.org/access/forms/frm0055.htm