Hurricane766
IS-IT--Management
Hi,
I have a datawindow with a number of rows being returned. One of the columns is a dropdownlistbox. I want this column's background color to change based on values in two other columns. Like this:
This sets the background color and works nicely... Except when you click on the arrow to open the drop down list - it's all black and as such none of the text for any of the items shows up.
I'm not sure why this is happening, I've even tried changing the color of the text to white to see if it will show up in the drop down but it doesn't - everything is still all black.
Does anyone have any ideas?
I have a datawindow with a number of rows being returned. One of the columns is a dropdownlistbox. I want this column's background color to change based on values in two other columns. Like this:
Code:
st_mod = 'action.Background.Mode=0'
st_ret = dw_main.Modify(st_mod)
IF st_ret <> '' THEN MessageBox(st_ret, st_mod)
st_mod = "action.Background.Color = '" &
+ String(0) &
+ "~tIf(compute_3 = compute_4," &
+ String(RGB(0,255,0)) &
+ ",If(compute_3 < compute_4," &
+ String(RGB(0,255,255)) &
+ ",If(compute_3 > compute_4," &
+ String(RGB(255,0,0)) &
+ "," &
+ String(RGB(0,0,0)) &
+ ")))'"
st_ret = dw_main.Modify(st_mod)
IF st_ret <> '' THEN MessageBox(st_ret, st_mod)
This sets the background color and works nicely... Except when you click on the arrow to open the drop down list - it's all black and as such none of the text for any of the items shows up.
I'm not sure why this is happening, I've even tried changing the color of the text to white to see if it will show up in the drop down but it doesn't - everything is still all black.
Does anyone have any ideas?