Display a calculated field in a grid

[dgrewe]

I have never had to do this before,
Client wants an Asterick to appear in a column in a grid if the duedate is greater then todays date. There is no filed in the table for it so it is on-the-fly for each record in the grid.
Where do you place it in the grid? I assume it is someplace in the grid.column.text1 object

calculation is iif(ttod(duedate) > date() , "*" , " ")

A search of all VFP Forums and FAQ's did not find anything on the subject.


David W. Grewe Dave

 

[SnyAc]

you can put the calculation in the controlsource for the column (data tab)

=iif(ttod(duedate) > date() , "*" , " ")

and disable the text control in the column so that it won't be part of the tab sequence...

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

 

[dgrewe]

Thanks Andy


David W. Grewe Dave

 

[GriffMG]

you might need to toggle the sparce property

Regards

Griff
Keep [Smile]ing