This is a follow-up to yesterday's "Which Approach to Conditionally & Dynamically"Create" Control on Report?" question.
I have a variable in a report which is assigned a value from a field/DB Text, vBF4_OBLIGATED_CHANGE and OBLIGATED_CHANGE, respectively. If this value is 0 or less, I want to change the (background) color of the control. Here is a block in the BEFORE GENERATE EEP: IF (.vBF4_OBLIGATED_CHANGE) <= 0 THEN PROPERTY BF4_OBLIGATED_CHANGE FONT_COLOR 'BLACK' PROPERTY BF4_OBLIGATED_CHANGE COLOR 'YELLOW' ELSE PROPERTY BF4_OBLIGATED_CHANGE FONT_COLOR 'BLACK' PROPERTY BF4_OBLIGATED_CHANGE COLOR 'WHITE' ENDIF This works. However, this statement does not : PROPERTY BF4_OBLIGATED_CHANGE COLOR 'CYAN' Nor does : PROPERTY BF4_OBLIGATED_CHANGE COLOR 'LIGHT CYAN' (Interestingly, each and every failed attempt changed the background to green.) Also interesting, these statements do work : PROPERTY BF4_OBLIGATED_CHANGE COLOR 'ActiveCaption' PROPERTY BF4_OBLIGATED_CHANGE COLOR 'AQUA' So, my questions are: 1) Which colors are available for changing the background of a DB Text in Reports? 2) Where are their "names" found/stored? 3) Can I add new colors or redefine existing, in either case using R,G,B values? Thanks, Steve in Memphis J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
