Jump to content
Sign in to follow this  
Dan-A

Changing field color...

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

As Far As I Know = AFAIK

Share this post


Link to post
Share on other sites

Thanks Lee.

Are there many more like that??

I only know HTH (Hope This Helps)

Dan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.