Screen Flicker

[Guest]

There is one form which has several tabs and I noticed when I moved my mouse
over the form itself, the form/screen flickers quickly everytime. It's like
the form is trying to refresh itself or something. Any ideas where I should
start looking with such symptoms? Thanks.
ck

 

[Allen Browne]

Yes, this is a problem with tab controls in Access 2003 on Windows XP.

This article explains the cause, and contains the code to find and change
all the affected controls in an mdb:
Flicker with tab controls
at:
http://allenbrowne.com/ser-46.html

 

[Guest]

Thanks, Allen.
ck

Yes, this is a problem with tab controls in Access 2003 on Windows XP.

This article explains the cause, and contains the code to find and change
all the affected controls in an mdb:
Flicker with tab controls
at:
http://allenbrowne.com/ser-46.html

 

[JohnB]

Hi. I hope someones still watching this thread. Allen,
does your code work on Access 2002? My db is 2002 and I
though it might be best to clean it up now because our
company has its PCs on a lease and they will all be
changed out in about a year and 2002 may be replaced with
2003. I use Tab Control for the dbs main switchboard and
Im sure I have many unconnected Labels in the forms.

Cheers, JohnB

 

[Allen Browne]

Yes. It finds the affected labels, and converts them to text boxes that look
like labels. And I have used it in A2002 for the reason you cite.

 

[Guest]

How do you create a text box that is not a field. I tried to do this by
making the control source [Clients].[Form] but didn't know how to name it.
Help appreciated.

 

[Guest]

Joan,
I don't know if I correctly understand your question (not sure what you are
attempting with "[Clients].[Form]" as your control source), but you can
simply leave the control source for a textbox blank, and it will be unbound.
Then you can put an expression in it which is simply a quote (like ="My
caption") and it will display this.
--
Darrell

How do you create a text box that is not a field. I tried to do this by
making the control source [Clients].[Form] but didn't know how to name it.
Help appreciated.
--
Joan

Yes, this is a problem with tab controls in Access 2003 on Windows XP.

This article explains the cause, and contains the code to find and change
all the affected controls in an mdb:
Flicker with tab controls
at:
http://allenbrowne.com/ser-46.html

 

[Guest]

Allen, you may not see this post since it has been over a year since you
posted your reply to the original questioner, but I wanted to express my
gratitude for your constant help on these newsgroups. Your post just saved my
hours of time and much consternation by putting your finger directly on a
problem I have occasionally encountered over the last 2 years, AND posting a
pre-cooked solution which worked perfectly. Thank you profoundly.

 

[Allen Browne]

Excellent!

 

[Janis in Minnesota]

I have loaded the code and run the program. I have a tab control with 15
tabs. When the user opens the main form, initially, this tab re-freshes
itself (probably 15 times would be my best guess). It looks crazy! Once
the main form is open it does not happen again.

This also occurs in our 2007 database as well.

Do I have a property setting wrong? Is there anything I can do so the tab
does not 'flicker' numerous times when the main form is opened?

Thank you sooo much for any advice!!!

Janis in Minnesota

 

[Jeanette Cunningham]

Janis,
do you have a subform on several of the tabs?
It is often suggested that you only a load a subform on a tab when the user
clicks on that tab, instead of loading all the subforms when the form loads.

Jeanette Cunningham

 

[Allen Browne]

Janis, I don't think your issue is the one addressed in that article, which
applies to the mouse being moved over controls in Access 2003 (perhaps
wihout SP3) on Win XP.

The way you describe your issue, it has to do with the form being requeried
about 15 times when it opens. This sounds much more like other issues, such
as:
- The source queries are set up, e.g. if they read a value from the form
that is not open yet, or use parameters.

- Conditional Formatting

- Cyclic triggering of events between main form and subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message