467,886 Members | 1,799 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,886 developers. It's quick & easy.

Conditional Formatting in Access 2003

I recently installed Access 2003 and immediately noticed problems with
applications that work fine in 2000 and XP. I use conditional
formatting on continuous forms for a number of reasons. When these
forms are opened in 2003, Access seems to go into a continuous loop.
Has anyone else experienced this problem? Does anyone know of a
solution short of not using conditional formatting in continuous
forms?

Here is an example:

http://www.bugnoaccess.kit.net/test1.zip

How to solve this?
Nov 12 '05 #1
  • viewed: 6561
Share:
4 Replies
Yes: have seen this bug.
No: no fix AFAIK.

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

"brAccess" <ca******@bol.com.br> wrote in message
news:e1**************************@posting.google.c om...
I recently installed Access 2003 and immediately noticed problems with
applications that work fine in 2000 and XP. I use conditional
formatting on continuous forms for a number of reasons. When these
forms are opened in 2003, Access seems to go into a continuous loop.
Has anyone else experienced this problem? Does anyone know of a
solution short of not using conditional formatting in continuous
forms?

Here is an example:

http://www.bugnoaccess.kit.net/test1.zip

How to solve this?

Nov 12 '05 #2
TC
Does that happen always, or unpredictably?

TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes: have seen this bug.
No: no fix AFAIK.

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

"brAccess" <ca******@bol.com.br> wrote in message
news:e1**************************@posting.google.c om...
I recently installed Access 2003 and immediately noticed problems with
applications that work fine in 2000 and XP. I use conditional
formatting on continuous forms for a number of reasons. When these
forms are opened in 2003, Access seems to go into a continuous loop.
Has anyone else experienced this problem? Does anyone know of a
solution short of not using conditional formatting in continuous
forms?

Here is an example:

http://www.bugnoaccess.kit.net/test1.zip

How to solve this?


Nov 12 '05 #3
There's a set of conditions that it applies to.

From memory, it it has to be a calculated field that is being conditionally
formatted, and the formatting seems to trigger a recalc, which triggers a
reformat, which triggers a recalc, which ...

Search groups.google.com for posts by Stephen Lebans on this issue. I think
he suggested that you can avoid the issue by assigning the conditional
formatting through code instead of through the interface?

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

"TC" <a@b.c.d> wrote in message news:1070421111.955277@teuthos...
Does that happen always, or unpredictably?

TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes: have seen this bug.
No: no fix AFAIK.

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

"brAccess" <ca******@bol.com.br> wrote in message
news:e1**************************@posting.google.c om...
I recently installed Access 2003 and immediately noticed problems with
applications that work fine in 2000 and XP. I use conditional
formatting on continuous forms for a number of reasons. When these
forms are opened in 2003, Access seems to go into a continuous loop.
Has anyone else experienced this problem? Does anyone know of a
solution short of not using conditional formatting in continuous
forms?

Here is an example:

http://www.bugnoaccess.kit.net/test1.zip

How to solve this?

Nov 12 '05 #4
TC
Ok, thanks.

Glad you got your other problem sorted!

TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
There's a set of conditions that it applies to.

From memory, it it has to be a calculated field that is being conditionally formatted, and the formatting seems to trigger a recalc, which triggers a
reformat, which triggers a recalc, which ...

Search groups.google.com for posts by Stephen Lebans on this issue. I think he suggested that you can avoid the issue by assigning the conditional
formatting through code instead of through the interface?

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

"TC" <a@b.c.d> wrote in message news:1070421111.955277@teuthos...
Does that happen always, or unpredictably?

TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes: have seen this bug.
No: no fix AFAIK.

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

"brAccess" <ca******@bol.com.br> wrote in message
news:e1**************************@posting.google.c om...
> I recently installed Access 2003 and immediately noticed problems with > applications that work fine in 2000 and XP. I use conditional
> formatting on continuous forms for a number of reasons. When these
> forms are opened in 2003, Access seems to go into a continuous loop.
> Has anyone else experienced this problem? Does anyone know of a
> solution short of not using conditional formatting in continuous
> forms?
>
> Here is an example:
>
> http://www.bugnoaccess.kit.net/test1.zip
>
> How to solve this?


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Dimitri Furman | last post: by
5 posts views Thread by Andrew Chanter | last post: by
1 post views Thread by GGerard | last post: by
2 posts views Thread by Filips Benoit | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.