Microsoft Office list of colours??

[rudeboymcc]

Hi. I'm trying to set a format property of a field in Access 2007.

at the moment it looks like £##.##[Black];-£##.##[Red]

This will make eerything positive black and negative red. However i want to use more colours and add things for 0 (make it green) but hte [Green] colour is very bright (hurts the eyes).

Is there a list of all the colours that office uses as text? i.e. Dark Green etc.

I've tried [Dark Green] but it just sees it as text.

 

[londonbairn]

You could do it in VBA (create sub to pass value, then call it text box onexit and form current event sending the value, and the sub can test if its - or + through select case, if whatever you wanted to use)

That way you can use any of the colour numeric codes, IIRC you cannot use colour codes in the format property you are currently entering, might be wrong.

 

[Meeko]

Not sure if 2007 differs from 2003 with regard to the formatting, but only the following colours are supported in 2003 :

[Black]
[Blue]
[Cyan]
[Green]
[Magenta]
[Red]
[White]
[Yellow]