If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting requiring Clicking twice to change records
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#2
|
|||
|
|||
Conditional Formatting requiring Clicking twice to change records
Correction:
The Conditional Formatting is Expression Is [FFlag] = -1 -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|