Changing color in countinuous form

Dina01

Registered User.
Local time
Today, 00:05
Joined
Apr 24, 2002
Messages
87
Hello I create a db in access97 and it has a continuous form that the background changes colors depending on what the condition is. It works fine in Access97 but when I convert it to Access XP, well it doesn't display the colors.....

Maybe I should mention , I have 12 textbox that are all overlaspe, and in each of them I have the condition...

example...
1.
=VraiFaux([Priorite]=1 Et [Code1]<>5 Et [HrsDebutCall] Est Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
2.
=VraiFaux([Priorite]=2 Et [Code1]<>5 Et [HrsDebutCall] Est Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
3.
=VraiFaux([Priorite]=3 Et [Code1]<>5 Et [HrsDebutCall] Est Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
4.
=VraiFaux([Priorite]=4 Et [Code1]<>5 Et [HrsDebutCall] Est Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
5.
=VraiFaux([Priorite]=1 Et [Code1]<>5 Et [HrsDebutCall] Est Pas Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
6.
=VraiFaux([Priorite]=2 Et [Code1]<>5 Et [HrsDebutCall] Est Pas Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
7.
=VraiFaux([Priorite]=3 Et [Code1]<>5 Et [HrsDebutCall] Est Pas Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
8.
=VraiFaux([Priorite]=4 Et [Code1]<>5 Et [HrsDebutCall] Est Pas Null;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
9.
=VraiFaux([Priorite]=1 Et [Code1]=5 ;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
10.
=VraiFaux([Priorite]=2 Et [Code1]=5 ;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
11.
=VraiFaux([Priorite]=3 Et [Code1]=5 ;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)
12.
=VraiFaux([Priorite]=4 Et [Code1]=5 ;" ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ";Null)

So I am not too sure where to add all of this....
";Null)

but when I view it in Acccess XP I can tell the color changed but it display only the ÛÛ with the different colors

I know that in Access XP there is Conditional Formatting, but I never used it so I am a littel confused...
 
Last edited:
Check the "Conditional Formating..." property for your report filed.

One allowed three conditions, that is, thee different colors.
 

Users who are viewing this thread

Back
Top Bottom