Submitted by jan_rifkinson on 2009/03/10 16:50
I have date field called DateDone
In DateDone equation I placed the following:
 
A:ItemColor=&H808080:ItemColor=
 
It is supposed to turn font grey when <CTRL>+M or context checkmark is used
but it doesn't
what should the formula be?
 
Thank you
 
--
Jan Rifkinson
Ridgefield CT USA

Comments

you're missing the letter for the second part and a seperater
Try this
 
A:ItemColor=&H808080|E:ItemColor=
 

jan_rifkinson

2009/03/10 18:23

In reply to by Tom

That was it but @ the same time it wasnt' what I wanted to do. 
I wanted the font to change to that  color..... eeeeeek
 
Does ForeColor command (presuming this means font color) only work w boolean field? If so, I don't understand why it shouldn't work with a done field which is essentially boolean.
 
Thanks.
 
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Pierre_Admin

2009/03/10 18:50

In reply to by jan_rifkinson

Have you tried using that auto-assign rule but with the ItemForeColor field?
 
A:ItemForeColor=&H808080|E:ItemForeColor=

jan_rifkinson

2009/03/10 19:17

In reply to by Pierre_Admin

Yes I did but maybe I did something wrong so I'm going to copy / paste yours to see what happens
 
I now realize my mistake: I forgot (or didn't know enough) to put 'item' in front of 'forecolor' so it read "itemforecolor"
 
Now that I've done that it works as it should. Thanks, Pierre.
 
Will I *ever* learn this program?
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Pierre_Admin

2009/03/10 19:35

In reply to by jan_rifkinson

I'm sure you will
 
and happy to see you back here and using IQ