473,245 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,245 software developers and data experts.

Conditional formatting with subforms

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
8 11979
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be...
4
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the...
2
by: Von Bailey | last post by:
I have a form where the conditional formatting is set on some fields to bold if certain conditions are met. However, when the conditions are met some of the data that is to bold is either not...
5
by: Andrew Chanter | last post by:
Does anyone know a way you can use conditional formatting to create a banded style view as is commonly seen on the internet. (In othe words the first record appears on a gray background, the 2nd...
1
by: GGerard | last post by:
Hello Is there a way to use a variable in the Conditional Formatting of a Textbox? Example : I want the background of a textbox in a continuous form to change color when the value of...
8
by: Typehigh | last post by:
I have many text fields with conditional formatting applied, specifically when the condition is "Field Has Focus". Without any events associated with the fields the conditional formatting works...
4
by: midlothian | last post by:
Hello, I have conditional formatting set up on a subform based on a calculated value in the underlying query. For instance, if Sales are >$1000, the query displays "Yes," otherwise it displays...
2
by: Filips Benoit | last post by:
Dear All, Access 2003 adp on SQL_server 2005 A continious form showing 1 month based on table 'CALENDAR_MONTH_GRID' and fill with a SP. Fields: Companyname, Day1, day2, etc. The value in the...
3
by: Steve Antrobus | last post by:
Hello all, I've seen many discussions regarding continuous forms in Access and how to highlight individual rows and they all seem to suggest conditional formatting as the only way. This is...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.