Change records back color in continious form

[Hassan]

Hello guys!

I have continious view form based on table. For each record here is a field "not available" represented by check box. What I would like to make is that when I click on this check box, whole line of the current record (all fields of current record) changes it's back color until this check box is not unchecked (deselected).
I am using MsAccess97.
Please, if you can help do so. I will appreciate that.

 

[pcs]

Hassan,

short answer for A97 is no....a2k has conditional formatting that would allow this (i think...)

if you really want to do this in A97 (and I mean you REALLY want to do it!)

Mike Gurman has posted some code that will do it...

see if this link helps:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/004538.html

(if the link on this page is broken, post again, as i think i have mike's code saved somewhere...i just got back in after a couple of days on the road, so it might take some time for me to reply)

hth,
al

 

[Rich]

"A couple of days on the road", are you in a rock group? The Strolling Bones perhaps? singing such classics as I Can't Get No Pension: yet

 

[pcs]

nah,
1 picked up a job a a part-time lorry driver

 

[hadwin]

Please update link to Mike Gurman's Code

Hi,

The link mentioned "http://www.access-programmers.co.uk...TML/004538.html " is out of date

If possible can you please publish or update the link to Mike Gurman's code?

I am trying to figure out how to do conditional formatting in Access 97, while using a continuous form.

Cheers,

Hadwin.

 

[Rich]

Although Mike made some subtle changes the principle's the same in the attachment here.

And there's another take in the example I posted here
http://www.access-programmers.co.uk/forums/showthread.php?p=298255#post298255