Split form event processing problem (1 Viewer)

I have created a split form in MS Access 2007. The Form's Current event checks if one of its text boxes contains a negative number: if it does, it sets its forecolor colour to red, otherwise it sets it to black. It's about as simple as context-sensitive formatting gets.

The only way I can get the colour-coding to work reliably is if I position the datasheet at the top of the split form and use the record navigation controls at the bottom. If I navigate through the records by placing the cursor on another row of the Datasheet, then the colour-coding is unreliable. Similarly if I position the Datasheet at the bottom of the split form and use the record selectors at the bottom, the colour coding is unreliable.

Had anyone come across this apparent bug, and more to the point is there a fix or a workaround?

OnCurrent event will only fire when the record gets focus so for this to work on a continious- or datasheet forms you have to use Conditional formatting.

something like this:

Expression Is [FieldInQuestion] < 0

JR