hello,
I been tryig to figure out a little issue for the past ehh few hours..
have about 100 records, each record has about 5 fields and 1 of them is status.
What i am trying to do is that if that status = done or status=active i want to set the whole row a certain color...
tried conditional color, it selects either just one field or the whole colum..
trying setting it to that color by: me.status.backcolor = vbRed..and i get the whole colomn..tried the expression way as well..i either get same results or everything gets selected...
any help is appreciated, i need some light in the dark world of access....
**Sry for double posting**
I been tryig to figure out a little issue for the past ehh few hours..
have about 100 records, each record has about 5 fields and 1 of them is status.
What i am trying to do is that if that status = done or status=active i want to set the whole row a certain color...
tried conditional color, it selects either just one field or the whole colum..
trying setting it to that color by: me.status.backcolor = vbRed..and i get the whole colomn..tried the expression way as well..i either get same results or everything gets selected...
any help is appreciated, i need some light in the dark world of access....
**Sry for double posting**