Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Screen Flicker

6 views
Skip to first unread message

Allen Browne

unread,
May 8, 2005, 7:42:29 AM5/8/05
to
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

--
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.

"CK" <C...@discussions.microsoft.com> wrote in message
news:0F8C5934-7F87-475C...@microsoft.com...
> 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


CK

unread,
May 8, 2005, 7:51:01 AM5/8/05
to
Thanks, Allen.
ck

JohnB

unread,
May 9, 2005, 9:35:52 AM5/9/05
to
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

>-----Original Message-----
>Thanks, Allen.
>ck
>
>"Allen Browne" wrote:
>
>> 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
>>
>> --
>> 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.
>>
>> "CK" <C...@discussions.microsoft.com> wrote in message

>> news:0F8C5934-7F87-475C-B307-
8643AE...@microsoft.com...


>> > 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

unread,
May 9, 2005, 10:57:56 AM5/9/05
to
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.

--
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.

"JohnB" <anon...@discussions.microsoft.com> wrote in message
news:0d4601c5549c$052cca60$a501...@phx.gbl...


> 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
>
>>-----Original Message-----
>>Thanks, Allen.
>>ck
>>
>>"Allen Browne" wrote:
>>
>>> 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
>>>

JoanOC

unread,
Jan 6, 2006, 1:35:01 PM1/6/06
to
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

Darrell

unread,
Jul 3, 2006, 12:54:01 PM7/3/06
to
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

Darrell

unread,
Jul 3, 2006, 12:57:02 PM7/3/06
to
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.
--
Darrell

Allen Browne

unread,
Jul 3, 2006, 9:45:10 PM7/3/06
to
Excellent!

--
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.

"Darrell" <Dar...@llu.com> wrote in message
news:760BADCA-8E43-4D7F...@microsoft.com...

Janis in Minnesota

unread,
Feb 21, 2008, 12:27:01 PM2/21/08
to
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

unread,
Feb 21, 2008, 7:04:14 PM2/21/08
to
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

"Janis in Minnesota" <JanisinM...@discussions.microsoft.com> wrote in
message news:FDEBB47A-C06F-43C5...@microsoft.com...

Allen Browne

unread,
Feb 21, 2008, 9:08:59 PM2/21/08
to
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

Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Janis in Minnesota" <JanisinM...@discussions.microsoft.com> wrote in
message
news:FDEBB47A-C06F-43C5...@microsoft.com...


>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 :)
>
> "Allen Browne" wrote:
>
>> 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
>>

0 new messages