conditional formatting

[SAC]

MS Access 2003

I have an app in 2000 that makes a control a color with conditional
formatting; however in Access 2003 there are no colors.

Any ideas?

Thanks.

 

[BruceM]

I don't understand your question. I have Access 2003, and there are colors
available for condtional formatting.

 

[SAC]

Thanks.

I wrote an app in 2000 and it displays color with conditional formatting.

When I load it onto a system running 2003 it does not show the colors.

Any ideas about this?

Thanks for your help.

 

[BruceM]

I have done a little checking on this, and have found that other users
reported a similar situation. I have not done enough research to know if it
is related to one service pack or another, but I do know that at least one
person reported having to re-create the Conditional Formatting. It may be
an example of a discontinuity in some situations between versions of Access.
Sorry I couldn't be of any more help, but perhaps a Google groups search
will yield some information I did not find.

 

[SAC]

I wrote some conditional formatting in 2000 and now when IK run it in 2003
it does not show. Yes, there is conditional formatting colors in 2003 and
when I look at the form in design view, the colors show, but when I look at
it in form view, I get no colors.

Any ideas?

Thanks.

 

[Jeanette Cunningham]

There is conditional formatting built in for A2003 (not sure for A2000)
Select the control >> Format >> Conditional Format >> choose the conditions
and the format. Easier than writing code.

Jeanette Cunningham

 

[SAC]

I have it working correctly on a Access 2000 computer, but when I put it on
an Access 2003 computer I don't see any colors.

 

[Jeanette Cunningham]

I haven't heard of this before. Access 2003 normally makes colors available
in the dialog for conditional formatting.
In Access 2003, when I choose Format >> Conditional Formatting,
I see the dialog, I can choose the Condition, the operator (between, equal
to etc) there are 2 text boxes to enter values, you can choose Bold, Italic,
Underline, next to Underline there is the paint pot symbol, when I click its
drop arrow I can choose a colour, there is an A for choosing text colour,
when I click its dropdown I can choose a colour.
What happens on your A 2003 computer. Can you see the paintpot and A
symbols? do they have a drop arrow on them?

Jeanette Cunningham

 

[SAC]

Thanks for you help.

I copied the program from an Access 2000 computer onto the computer with
Access 2003 and it works fine. I don't know what caused it to stop working
on the Access 2003 machine, but all is well now.

Thanks again.

 

[Jeanette Cunningham]

Glad you got it working.

Jeanette Cunningham

Thanks for you help.

I copied the program from an Access 2000 computer onto the computer with
Access 2003 and it works fine. I don't know what caused it to stop
working on the Access 2003 machine, but all is well now.

Thanks again.

 

[Linq Adams via AccessMonster.com]

Colors are frequently a problem with Access 2003 when your OS is Windows XP.
Controls on tabbed pages flicker, tabbed pages themselves appear white, even
when their background is set to "Transparent" which should give them the
color of the underlying Detail section of the form. The culprit is the XP
Themes. These problems occur if the desktop is set to XP Themes, and can be
eliminated by switching from "XP Themes" to "Classic." According to Allen
Browne, ACC2003/SP3 corrected this problem. We know, of course, that SP3
actually delivered more bugs than it fixed!