D
DaveR (UK)
Hi all,
I have a contnious form to which I have applied conditional formatting. The
formatting works as expected until you started moving around the records them
selves.
The formatting applies changes to a transparent text box back colour
accorinding to the following rules...
Currently Selected Record - Blue - [VisitID]=[CurrentPKey]
Record has both a timein and timeout value - red - [TimeIn] Is Not Null And
[TimeOUt] Is Not Null
Record has a timein value - green - [TimeIN] Is Not Null
Where CurrentPKey is a field that is updated to the VisitID of the current
record using the Form_Current event (from Labans site)
The problem seems to occur when the current record changes and the textbox
sometimes 'forgets' it original format - for example, the textbox may be
coloured red, when it is selected this changes to blue - however when another
record is selected the text box reverts to the default format...
Has anyone any ideas how I might deal with this ??
If you need any other information, please let me know - any help grately
appreciated...
I have a contnious form to which I have applied conditional formatting. The
formatting works as expected until you started moving around the records them
selves.
The formatting applies changes to a transparent text box back colour
accorinding to the following rules...
Currently Selected Record - Blue - [VisitID]=[CurrentPKey]
Record has both a timein and timeout value - red - [TimeIn] Is Not Null And
[TimeOUt] Is Not Null
Record has a timein value - green - [TimeIN] Is Not Null
Where CurrentPKey is a field that is updated to the VisitID of the current
record using the Form_Current event (from Labans site)
The problem seems to occur when the current record changes and the textbox
sometimes 'forgets' it original format - for example, the textbox may be
coloured red, when it is selected this changes to blue - however when another
record is selected the text box reverts to the default format...
Has anyone any ideas how I might deal with this ??
If you need any other information, please let me know - any help grately
appreciated...