Changing field color...

[Dan-A]

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

[MarkWilson]

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.

[-Queue-]

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

[Dan-A]

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

[-Queue-]

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

[Dan-A]

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.

[Lee Smith]

As Far As I Know = AFAIK

[Dan-A]

Thanks Lee.

Are there many more like that??

I only know HTH (Hope This Helps)

Dan

[QuinTech]

Dan, STFW (just kidding!)

Here's a good one.

J