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
|
|||
|
|||
Form flickers
Is there a way to stop the flicker? I am locking or
unlocking fields on my form and subform OnCurrent based on a certain criteria. I have it all working correctly, but each time you move from one record to the next the form flickers (in a very irritating manner) while it sets the properties. |
#2
|
|||
|
|||
Form flickers
Several possible issues, Carolyn, but one idea that may help is to only
change the properties if they need changing. This example test "SomeField", and it is blank than locks "AnotherField" if is it not already locked: Dim bLock as Boolean bLock = IsNull(Me.SomeField) With Me.AnotherField If .Locked bLock Then .Locked = bLock End If End If -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carolyn" wrote in message ... Is there a way to stop the flicker? I am locking or unlocking fields on my form and subform OnCurrent based on a certain criteria. I have it all working correctly, but each time you move from one record to the next the form flickers (in a very irritating manner) while it sets the properties. |
#3
|
|||
|
|||
Form flickers
What are the "other possible issues?" Since I have two
databases and 9 forms in each where I am setting the locks, I'd like to find an easier way to solve the problem if possible. Somebody suggested there is a way to "turn off" showing an action is happening on a form... -----Original Message----- Several possible issues, Carolyn, but one idea that may help is to only change the properties if they need changing. This example test "SomeField", and it is blank than locks "AnotherField" if is it not already locked: Dim bLock as Boolean bLock = IsNull(Me.SomeField) With Me.AnotherField If .Locked bLock Then .Locked = bLock End If End If -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carolyn" wrote in message ... Is there a way to stop the flicker? I am locking or unlocking fields on my form and subform OnCurrent based on a certain criteria. I have it all working correctly, but each time you move from one record to the next the form flickers (in a very irritating manner) while it sets the properties. . |
#4
|
|||
|
|||
Form flickers
Some other causes:
Conditional formatting: http://allenbrowne.com/bug-05.html Unattached controls whose parent is not the form: http://allenbrowne.com/ser-46.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. wrote in message ... What are the "other possible issues?" Since I have two databases and 9 forms in each where I am setting the locks, I'd like to find an easier way to solve the problem if possible. Somebody suggested there is a way to "turn off" showing an action is happening on a form... -----Original Message----- Several possible issues, Carolyn, but one idea that may help is to only change the properties if they need changing. This example test "SomeField", and it is blank than locks "AnotherField" if is it not already locked: Dim bLock as Boolean bLock = IsNull(Me.SomeField) With Me.AnotherField If .Locked bLock Then .Locked = bLock End If End If "Carolyn" wrote in message ... Is there a way to stop the flicker? I am locking or unlocking fields on my form and subform OnCurrent based on a certain criteria. I have it all working correctly, but each time you move from one record to the next the form flickers (in a very irritating manner) while it sets the properties. |
#5
|
|||
|
|||
Form flickers
thank you for your help.
-----Original Message----- Some other causes: Conditional formatting: http://allenbrowne.com/bug-05.html Unattached controls whose parent is not the form: http://allenbrowne.com/ser-46.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. wrote in message ... What are the "other possible issues?" Since I have two databases and 9 forms in each where I am setting the locks, I'd like to find an easier way to solve the problem if possible. Somebody suggested there is a way to "turn off" showing an action is happening on a form... -----Original Message----- Several possible issues, Carolyn, but one idea that may help is to only change the properties if they need changing. This example test "SomeField", and it is blank than locks "AnotherField" if is it not already locked: Dim bLock as Boolean bLock = IsNull(Me.SomeField) With Me.AnotherField If .Locked bLock Then .Locked = bLock End If End If "Carolyn" wrote in message ... Is there a way to stop the flicker? I am locking or unlocking fields on my form and subform OnCurrent based on a certain criteria. I have it all working correctly, but each time you move from one record to the next the form flickers (in a very irritating manner) while it sets the properties. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pop up form doesn't link correctly, PLEASE HELP!!! | Sandra | Using Forms | 4 | June 19th, 2004 01:55 AM |
form doesn't update!!!!! | manish | Using Forms | 4 | June 15th, 2004 11:24 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
Can't update table from Form | sara | Using Forms | 3 | June 11th, 2004 02:12 PM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |