G
Guest
The Database Forms will paint and repaint in different Colors and Fonts When
accessing or changing data. What causes this?
accessing or changing data. What causes this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Could be several things.
If you are using Access 2003 on Windows XP, and particularly if you have
controls that are not sitting directly on the form (e.g. unattached labels
on the page of a tab control, or controls in an option group), they are
constantly redrawn as the mouse moves across them. For further info and
workaround for this issue, see:
Flicker with tab controls
at:
http://allenbrowne.com/ser-46.html
Another possible is Conditional Formatting (CF). Particularly if you have
calculated controls that are conditionally formatted, the CF can trigger a
recalculation which triggers a reformatting which triggers a ... Well, you
get the idea. Temporarily remove any CF to verify this is the issue. (This
issue seems to be better in the latest service pack of Access 2003, so
applies more to 2000 or 2002.)
Another cause is the circular triggering of events, which again puts Access
into an endless recalculation loop. For example, if you had a subform whose
Current event requeried the main form, the main form reloads (responding to
the requery) which causes it to load the subform records again, which fires
its Current event, which requeries the main form, and around you go. It is
actually quite easy to set of this kind of triggering.
If you are using Access 2003 on Windows XP, and particularly if you have
controls that are not sitting directly on the form (e.g. unattached labels
on the page of a tab control, or controls in an option group), they are
constantly redrawn as the mouse moves across them. For further info and
workaround for this issue, see:
Flicker with tab controls
at:
http://allenbrowne.com/ser-46.html
Another possible is Conditional Formatting (CF). Particularly if you have
calculated controls that are conditionally formatted, the CF can trigger a
recalculation which triggers a reformatting which triggers a ... Well, you
get the idea. Temporarily remove any CF to verify this is the issue. (This
issue seems to be better in the latest service pack of Access 2003, so
applies more to 2000 or 2002.)
Another cause is the circular triggering of events, which again puts Access
into an endless recalculation loop. For example, if you had a subform whose
Current event requeried the main form, the main form reloads (responding to
the requery) which causes it to load the subform records again, which fires
its Current event, which requeries the main form, and around you go. It is
actually quite easy to set of this kind of triggering.