Add more fonts to conditional formatting

[Guest]

Is it possible to add more Font colour options to Conditional formatting in
Access 2003?
Thanks.

 

[Douglas J. Steele]

Such as?

 

[Guest]

I have a form and the detail section back colour is 12189695.
I want zeros to be invisible but there appears to be a limited choice in
conditional formatting for text colour. I obviously need colour 12189695.

 

[Guest]

Sorry Douglas, just realised when you set a currency data type in a table it
adds an automatic default of 0. I have removed the default and all is well.
Now I just need to delete all zeros in currency fields for existing records.
Could I do this with an Update query changing 0 to Is Null? I appreciate
that if I did this I would need to use Nz in form calculations on these
fields. Also should I delete existing conditional formatting or is the
processing power negligable. There is only 1 condition, if field is equal to
0 font colour = ..
Thanks and Im sorry if I've wasted your time.

 

[Douglas J. Steele]

Yes, you should be able to use an Update query to do what you want (provided
the field in question hasn't been set to Required)

BTW, take a look at the Format property (or function). It actually allows
you to specify up to 4 different format strings for a particular field: one
for positive values, one for negative values, one for zeroes and one for
Null values. That means that you could use a format like $#,##0;($#,##0);""
and have blank show for zero values.

?Format(23, "$#,##0;($#,##0);""""")
$23
?Format(-50, "$#,##0;($#,##0);""""")
($50)
?Format(0, "$#,##0;($#,##0);""""")

?Format(Null, "$#,##0;($#,##0);""""")

 

[BruceM]

For future reference you have millions of colors from which to choose. Open
the property sheet: select the text box, detail section, or whatever, then
click View > Properties (or find the Properties icon on the toolbar, or
right click the control and select Properties). Click the Format tab, and
enter the number in either Fore Color or Back Color as needed. You can also
click into Fore Color or Back Color, click the three dots, then click the
Define Custom Colors button. This is how it works in Access 2000, but I
expect it's similar in other versions.