By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Conditional formatting with subforms

P: n/a
Given:
Access 2002/2003
A subform in datasheet or continuous view, placed on a tab page (this last
may or may not matter)
Conditional formatting applied to some controls on the subform -
format expressions are the same for all controls

Under some undetermined circumstances, when such subform is displayed, the
controls on the subform start to visibly flicker, the cursor in the subform
stops blinking, and CPU utilization goes to 100%. Subjectively, it almost
looks as if Access gets into an infinite loop trying to "refresh" the
subform. As far as I can tell, the only things that get Access out of the
loop are:
Moving the mouse over the flickering controls (the mouse pointer has to go
over a record other than the current record to stop the flickering)
Switching the focus from the Access window to another window and then back.

The flicker is not spurious: if a subform is affected, it happens every
time the subform is displayed, and vice versa - it never happens to some
subforms with conditional formatting.

The flicker does not happen if there are no records on the subform.
Subforms in form view are not affected - more than one record has to be
displayed at the same time for the problem to happen.

Once the flicker is stopped by one of the methods above, it does not happen
again until the subform is closed and reopened, or until a new recordset is
bound to it.

All in all, this looks like a bug in conditional formatting - if anyone
have seen this, are there any workarounds? Thanks.

--
(remove a 9 to reply by email)
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Purely a guess ----

Are you trying to apply conditional formatiing to the same control more than
once causing conditional formatting to cycle between the two formats?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...
Given:
Access 2002/2003
A subform in datasheet or continuous view, placed on a tab page (this last
may or may not matter)
Conditional formatting applied to some controls on the subform -
format expressions are the same for all controls

Under some undetermined circumstances, when such subform is displayed, the
controls on the subform start to visibly flicker, the cursor in the subform
stops blinking, and CPU utilization goes to 100%. Subjectively, it almost
looks as if Access gets into an infinite loop trying to "refresh" the
subform. As far as I can tell, the only things that get Access out of the
loop are:
Moving the mouse over the flickering controls (the mouse pointer has to go
over a record other than the current record to stop the flickering)
Switching the focus from the Access window to another window and then back.

The flicker is not spurious: if a subform is affected, it happens every
time the subform is displayed, and vice versa - it never happens to some
subforms with conditional formatting.

The flicker does not happen if there are no records on the subform.
Subforms in form view are not affected - more than one record has to be
displayed at the same time for the problem to happen.

Once the flicker is stopped by one of the methods above, it does not happen
again until the subform is closed and reopened, or until a new recordset is
bound to it.

All in all, this looks like a bug in conditional formatting - if anyone
have seen this, are there any workarounds? Thanks.

--
(remove a 9 to reply by email)

Nov 13 '05 #2

P: n/a
On Jun 04 2004, 05:21 pm, "PC Datasheet" <no****@nospam.spam> wrote in
news:SJ*******************@newsread2.news.atl.eart hlink.net:
Are you trying to apply conditional formatiing to the same control
more than once causing conditional formatting to cycle between the two
formats?


I don't see how you can apply conditional formatting to the same control
more than once - there is only one FormatConditions collection for a
control. There may be more than one format condition per control, but
that's the whole point of using conditional formatting.

The number of format conditions being used has no relevance in this case -
the problem may happen when there is any number of them between one and
three.

--
remove a 9 to reply by email
Nov 13 '05 #3

P: n/a
Dimitri is it possible for you to send me the MDB with this Form so I
can have a look at the issue. I only installed Office 2003 in the last
week so I have not looked at all of the published/posted CF bugs to this
point.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...
On Jun 04 2004, 05:21 pm, "PC Datasheet" <no****@nospam.spam> wrote in
news:SJ*******************@newsread2.news.atl.eart hlink.net:
Are you trying to apply conditional formatiing to the same control
more than once causing conditional formatting to cycle between the two formats?

I don't see how you can apply conditional formatting to the same

control more than once - there is only one FormatConditions collection for a
control. There may be more than one format condition per control, but
that's the whole point of using conditional formatting.

The number of format conditions being used has no relevance in this case - the problem may happen when there is any number of them between one and three.

--
remove a 9 to reply by email


Nov 13 '05 #4

P: n/a
On Jun 04 2004, 07:50 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WW****************@linvalid.com> wrote in
news:cV*********************@ursa-nb00s0.nbnet.nb.ca:
Dimitri is it possible for you to send me the MDB with this Form so I
can have a look at the issue. I only installed Office 2003 in the last
week so I have not looked at all of the published/posted CF bugs to this
point.


Thanks Stephen. The mdb is a front end for SQL Server database - I'll try
to reproduce the problem in a standalone mdb and send that to you. Might
take a couple of days.

BTW, I remember seeing this in Access 2002, so it's not a new bug.

After some googling, it seems that this is a known issue after all:
http://www.google.com/groups?threadm...59b9%40posting
..google.com
http://allenbrowne.com/bug-05.html

I'll see if Allen's suggestion to get rid of calculated controls fixes it
in this case.

--
remove a 9 to reply by email
Nov 13 '05 #5

P: n/a
I figured you had already read about Allen's notes on this issue and
that yours was something new.
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...
On Jun 04 2004, 07:50 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WW****************@linvalid.com> wrote in
news:cV*********************@ursa-nb00s0.nbnet.nb.ca:
Dimitri is it possible for you to send me the MDB with this Form so I can have a look at the issue. I only installed Office 2003 in the last week so I have not looked at all of the published/posted CF bugs to this point.

Thanks Stephen. The mdb is a front end for SQL Server database - I'll

try to reproduce the problem in a standalone mdb and send that to you. Might take a couple of days.

BTW, I remember seeing this in Access 2002, so it's not a new bug.

After some googling, it seems that this is a known issue after all:
http://www.google.com/groups?threadm...a6d59b9%40post
ing .google.com
http://allenbrowne.com/bug-05.html

I'll see if Allen's suggestion to get rid of calculated controls fixes it in this case.

--
remove a 9 to reply by email


Nov 13 '05 #6

P: n/a
Yes, Dimitri. Conditional Formatting is very prone to the kind of
flicker/endless loops that you describe.

There is an example at:
http://allenbrowne.com/bug-05.html
where the resuls of calculated controls are not displayed because Access
gets stuck in its endless formatting loop.

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

"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...
Given:
Access 2002/2003
A subform in datasheet or continuous view, placed on a tab page (this last
may or may not matter)
Conditional formatting applied to some controls on the subform -
format expressions are the same for all controls

Under some undetermined circumstances, when such subform is displayed, the
controls on the subform start to visibly flicker, the cursor in the subform stops blinking, and CPU utilization goes to 100%. Subjectively, it almost
looks as if Access gets into an infinite loop trying to "refresh" the
subform. As far as I can tell, the only things that get Access out of the
loop are:
Moving the mouse over the flickering controls (the mouse pointer has to go
over a record other than the current record to stop the flickering)
Switching the focus from the Access window to another window and then back.
The flicker is not spurious: if a subform is affected, it happens every
time the subform is displayed, and vice versa - it never happens to some
subforms with conditional formatting.

The flicker does not happen if there are no records on the subform.
Subforms in form view are not affected - more than one record has to be
displayed at the same time for the problem to happen.

Once the flicker is stopped by one of the methods above, it does not happen again until the subform is closed and reopened, or until a new recordset is bound to it.

All in all, this looks like a bug in conditional formatting - if anyone
have seen this, are there any workarounds? Thanks.

--
(remove a 9 to reply by email)

Nov 13 '05 #7

P: n/a
On Jun 04 2004, 10:16 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WW****************@linvalid.com> wrote in
news:m2*********************@ursa-nb00s0.nbnet.nb.ca:
I figured you had already read about Allen's notes on this issue and
that yours was something new.
:-)


It would have helped if I searched before posting...

In this particular case, there was a hidden calculated textbox placed under
a visible textbox on a continuous form. Placing the hidden box beside the
visible one so that there was no overlap fixed the flicker.

--
remove a 9 to reply by email
Nov 13 '05 #8

P: n/a
On Jun 04 2004, 11:21 pm, "Allen Browne" <Al*********@SeeSig.Invalid> wrote
in news:40**********************@freenews.iinet.net.a u:
Yes, Dimitri. Conditional Formatting is very prone to the kind of
flicker/endless loops that you describe.

There is an example at:
http://allenbrowne.com/bug-05.html
where the resuls of calculated controls are not displayed because Access
gets stuck in its endless formatting loop.


Thanks Allen, I did find your writeup on this problem after posting. What's
interesting is that when I opened your demo form in Access 2002, it
actually worked fine - the calculated controls were displayed for all rows.

From what I've seen, the problem might start happenning for no clear
reason, then disappear after making some apparently unrelated design
changes. Go figure.

--
remove a 9 to reply by email
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.