Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Ellick Yeung
  Where is Ellick Yeung?
 
 Hong Kong
 Ellick Yeung
 Tags
Subject: RE: Text box fore color in a grid
Thread ID: 189072 Message ID: 189074 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Wednesday, August 13, 2008 10:08:26 AM         
   


> Hi all,
>
> I am wondering if we can set the Forecolor of a specific text box in a grid depanding on its value.
>
> I used the SETALL method to set the back or fore color for the whole column but I don't know how to reference the text box of a column.
>
> Thanks!

Hi Ellick -

You can use the column.DynamicForeColor property. If you want one particular column only, you do not need SetAll():
LOCAL oForm as Form
oForm = CREATEOBJECT('TestForm')
oForm.Show(1)
RETURN

DEFINE CLASS TestForm as Form
	AutoCenter = .T.
	PROCEDURE Load
		LOCAL i
		CREATE CURSOR temp (test Int)
		FOR i = 1 TO 10
			INSERT INTO temp VALUES (i)
		ENDFOR
		GO TOP
	ENDPROC

	ADD OBJECT Grid1 as Grid
	PROCEDURE Grid1.Init()
		This.Column1.DynamicForeColor = "Iif(test%2=0,RGB(255,0,0),RGB(0,0,0))"
	ENDPROC
ENDDEFINE



hth
-Stefan

ENTIRE THREAD

Text box fore color in a grid Posted by Ellick Yeung @ 8/13/2008 9:52:10 AM
RE: Text box fore color in a grid Posted by Stefan Wuebbe @ 8/13/2008 10:08:26 AM
RE: Text box fore color in a grid Posted by Ellick Yeung @ 8/13/2008 10:55:26 AM
RE: Text box fore color in a grid Posted by surinder singh @ 8/13/2008 11:04:56 AM
RE: Text box fore color in a grid Posted by Stefan Wuebbe @ 8/13/2008 12:17:42 PM
RE: Text box fore color in a grid Posted by Jun Tangunan @ 8/13/2008 1:13:57 PM
RE: Text box fore color in a grid Posted by Ellick Yeung @ 8/14/2008 4:56:36 AM
RE: Text box fore color in a grid Posted by surinder singh @ 8/13/2008 10:09:56 AM
RE: Text box fore color in a grid Posted by Mustapha Bihmouten @ 8/13/2008 10:11:24 AM
RE: Text box fore color in a grid Posted by Jun Tangunan @ 8/13/2008 10:14:53 AM