Having to click twice to move focus

[missinglinq]

Was writing a little routine for someone who needed, with a datasheet or continuous form, to have FieldTwo's back color change when FieldOne has focus. I added a boolean field, FFlag, and set it with the following code:

Private Sub FieldOne_GotFocus()
 Me.FFlag = -1
End Sub

Private Sub FieldOne_LostFocus()
 Me.FFlag = 0
End Sub

and then used Conditional Formatting for FieldTwo

Expression Is [FieldOne] = -1

with the back color set as desired.

This works as expected with one exception. If you move to another control within the current record, everything works correctly. But if you try to move to a different record with the mouse, the formatting disappears from FieldTwo, but the cursor stays on the FieldOne of the current record! In order to go to another record you have to click on it a second time!

I've tried everything I can think of, including recreating the scenario with a new db, made from scratch, in case it was some weird type of corruption, with no luck.

If the Conditional Formatting is removed, the form works as it normally would!

Anyone with any ideas?

Running Access 2003/SP2 on Windows XP

Thanks!

Linq

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

Correction:

The Conditional Formatting is:

Expression Is [FFlag] = -1

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

Things that go BUMP in the night!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!