jhomer Posted August 30, 2005 Posted August 30, 2005 I have a database which lists inventory which is ready to be shipped on a scheduled date. I would like to be able to highlite (in a red font) material which is marked as not shipped and has been in the system for more the 24 hrs. is there an easy way to do this? at the moment i am thinking about performing a find and looping through the found set to color the text i need. and when the shipment is marked as shipped looping through again to return the color to black. If anyone has a better idea please let me know.
Walter B Posted September 1, 2005 Posted September 1, 2005 create a calc field on your display layout. Pickup the text field you want to hilite and using TextColor in Text Formatting conditionally set your text color. Anyway, that's how I'd do it.
Nissim Posted September 6, 2005 Posted September 6, 2005 Hi, Create a calculation field by this way : TextColor ( FieldName ; RGB ( 255; 0 ; 0 )) 255;0;0 is for red color
Recommended Posts
This topic is 7086 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now