I have always used conditional formatting
to color the background of an active row in a continuous form
using Access 2003
and Windows 7
. However, I find that in Windows 8 conditional formatting doesn't appear to work
other than when the form first opens. Any real time changes don't seem to happen.
Here's the code I am using:
This runs OnCurrent:
'Set Record Selector: 'Form has an unbound field ctlCurrentRecord
If fTestForControl(frmForm, "ctlCurrentRecord") Then
![ctlCurrentRecord] = frmForm.SelTop
If IsNull(![ID]) Then
![ID].Tag = ![ID].Value 'set ID.Tag
And my conditional formatting
is set to:
Expression Is: [ID].Tag=[ID]
In the past this has always changed the backcolor of the control "Rowcolor" to a different color for the active record. In Windows 8 it appears to change it when the form first opens but selecting a new record does not update the color as it did in Windows 7 - the first row remains colored.
Anyone know what is happening here and how I can fix it?
Thanks in advance.