Hi

I have a legacy app that uses a Farpoint spreadsheet control (Ver 2.5) to display a number of "Hold Reasons". Of these lines some are "Disabled" and the fore color is coded to be vbGreyText.

The problem is when the .forecolor is set it is a different value to vbGreyText.
ie
Before : forecolor = 0, vbGrayText = -2147483631

Code : sprd.forecolor = vbgreytext

After : forecolor = 10070188, vbGrayText = -2147483631

At a later stage in the application the forecolor is used to check if any operation can be done on the row and if is equals vbGrayText no operation can be performed. As the two values are different it does allow operations.

Anybody any ideas why the values are different?

Thanks in advance

Daz

vbgraytext is a system color, while the property forecolor seems that returns a RGB color (in your case 0x99A8AC).
try converting vbgraytext in the real RGB color using the GetSysColor API:

Private Declare Function GetSysColor Lib "user32" (ByVal nIndex As Long) As Long

if sprd.forecolor = GetSysColor(vbGrayText And &hFFF)

to see if that works.
But sometimes it doesn't, I saw already controls that do not set exactly the color you ask for, like the MSFlexGrid. This is why I never use the color to check program settings, but I use a local internal data.

Thanks,

May take the sledge hammer approach and hard code it to and check for vbRed (not my choice of approach but the easiest fix)

I hope there is only one version of red!!!

Thanks again

Daz