>>>>Does anyone have or know of a spreadsheet-style grid? I need a grid that can sub-total/total records within the grid, perhaps using different colors for the Total records. It can be read-only as I don't have to enter data in the grid. I just need it for display, but I want the user to be able to filter the data based on certain criteria and have the sub-totals/totals refresh.
>>>>
>>>>Thanks!
>>>>Elyse
>>>
>>>I use an Excel Worksheet control on a VFP form. Then I put @sum() formulas in the appropriate cells.
>>
>>How do you do this? Where did you get an Excel Worksheet control from?
>
>It came from MS with VFP 6. It is an activeX Control, and as long as it is in your VFP Controls List (see VFP Options sheet), you can drop this control on the form. Of course your users have to have Excel installed. If this is not an option, you may have to revert to the grid. In my invoicing form, I used textboxes that kept running totals of grid columns.

I found the Worksheet control. How do I get a list of Properties, etc. so I can load up the Worksheet and respond to Clicks,DoubleClicks, etc.?