My OnCurrent Event seems to cause one of my continuous Access 2k form to flicker. I will breifly explain below. I'm using a basic method to highlight the selected row in a continuous form by using a control (TxtCurrentRecord) as the background with conditional formatting to change the color of this control to yellow when the value of this field = a hidden control called TxtID which has a control source of the unique product id. The displayed controls on the form are set to transparent and are overlayed directly over TxtCurrentRecord which is expanded to the width of all the displayed controls.
OnCurrent Event of the form ... Me.TxtCurrentRecord = Me.TxtID
The conditional formatting basically sets the background & font colors of TxtCurrentRecord to Yellow where the field value = TxtID, thus highlighting the current record.
This all works except in one form where the method is being used. Each time I click a different record to make it the current the form basically flickers (kind of like a refresh or requery) but I'm not getting a Calculating ... in the status bar, just the flickering.
I use this same method in several other forms and I don't get the flicker. If I remove the displayed controls from on top of the TxtCurrentRecord control then the flicker stops but obviously I need the controls that control because that's what does the highlighting.
Any ideas will be appreciated ...