August 30, 200520 yr 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.
September 1, 200520 yr 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.
September 6, 200520 yr Hi, Create a calculation field by this way : TextColor ( FieldName ; RGB ( 255; 0 ; 0 )) 255;0;0 is for red color
Create an account or sign in to comment