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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    SRBENET 
×
×
  • Create New...

Important Information

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