Hi All,

Based on user input i would like to change the color of a date field.

I thought i could just put the function below in the "auto-enter" portion

of my dte_finish field but it does not work. I used GetAsText because i think

the TextColor function only works on text and not date fields.

TextColor ( GetAsText ( dte_Finish ) ; RGB ( 255; 0; 0) )

Help please!!

--Dan

Two options.

Try this previous post on changing the background colour.

Option two is field stacking.

Create a calculation field formatted to a different colour that will display if the criteria is met.

TextColor ( GetAsText ( dte_Finish ) ; RGB ( 255; 0; 0) ) will always return a red text result. There is no test for user input here.

Queue, I know there is no test...

this will be part of a case function etc.

My problem is i can't get that simple portion to return red text.

It works fine on a number or text field, but does not work on a date field.

All i can think of so far is to use what we did prior to textcolor function

(stack fields on top of each other)

Thanks

--Dan

It will only work on text fields, AFAIK. The result of your calculation would need to be text and not date.

thanks

i'm afraid my english isn't good enough....what is AFAIK??

i was able to test the function on a number field and it did return

the color red just like on a text field. The rest of the field types

seem to return black text only.

As Far As I Know = AFAIK

Thanks Lee.

Are there many more like that??

I only know HTH (Hope This Helps)

Dan

Dan, STFW (just kidding!)

Here's a good one.

J