Conditional Formatting when Record is Selected

[Rosebud]

Does anyone know how to activate conditional formatting not just for when the control gets the focus, but for when the record gets selected?

I have a long list of students. When the user selects one of the records, I would like for all the controls in this record to be highlighted.

Any ideas?

Thanks,
Rosebud

 

[Abby N]

Hi Rosebud. If I understand your question properly then this link my help you out. It details how to change the background of the selected record in a continuous form and even includes a sample database. Hope it helps
http://www.mvps.org/access/forms/frm0047.htm

~Abby

 

[Rosebud]

Hi Abby!

Okay, well I actually have been to that site and I tested it, and for some reason I couldn't get it to work. Were you able to download that conform.zip file? On my computer when I tried to open/save it I just kept getting Acrobat Reader installation instructions but no sign of a document, file, or database? If you have downloaded it, would you mind e-mailing it to me if it's not too big? If not, that's okay.

radams@camp-blair.com

Thanks a lot Abby.

PS: I still haven't figured out that thing with the form requery and refreshing the screen, but when I do I will let you know.

[This message has been edited by Rosebud (edited 04-11-2001).]

 

[Abby N]

I've emailed you the example databese. Hope it helps.

~Abby