I also allow editing in grids, and have found them very useful. The problems with grids are their very picky and/or non-standard behavior with regard to some other VFP mechanisms, most notably views, toolbars, event firing sequences, and specific control inside columns.

Do you use toolbars in your app?

Eric Shaneson
Cutting Edge Consulting

>>>>I never allow editing ina grid so the gird issue is a non-issue for my >systems, however you are right that if you allow editing in a grid then you >must deal with whether the activecontrol is the grid.
>>>
>>>I am very curious. Why you don't allow editing in grids and how do you replace them?
>>
>>Silvio,
>>
>>I don't allow editing in grids because grids are a beast from hell. There are many nuances and quirks to grids, especially when you are trying to deal with data validation.
>>
>>I don't "replace" the grid. It is used to select a record and other controls are used to edit the data. I use discrete textboxes and the such for editing. If the client insists on editing directly in a grid, I let think that's what they are doing by formatting and placing the textboxes over the current grid row.
>>
>>If you want to know more about why I limit the editing in grids, just read this thread or any of the many others about all the problems folks run into when dealing with grids and editing. Also read the ones about how to get controls other than the default textbox to work right.
>
>I find this very interesting (and don't mean to be contradictory here since I'm sure experiences vary), since I have numerous apps that use grids for data entry and/or maintenance. One in particular is an order entry form for a quite huge company ($350 mil/yr) that processes thousands of line items per week from a table currently holding about 250,000 records...and the grid has data validation and combo boxes in it to boot, plus logic that controls which columns for a given row are enabled based upon answers in other column(s). It works without a hitch.
>
>What's more, every Payment Receipts, Journal Entry, Voucher Entry, Select For Payment, etc. processing application I write uses a grid. And personally, I use grids to in an app that maintains my hobby (running tape trees for sharing live music), which uses a view with several hundreds of records displayed/edited at a time. I have zero problems with any of them.
>
>Now, I'm not going to say that the first time I tried to use a grid for data entry I just dropped it on the form, bound the controls and went about my business. But after wrestling with them and getting a handle on the beast I have found grids to be trouble free and probably my favorite control in VFP. And off the top of my head at least one method that didn't work in 5.0 has been corrected in 6.0...Activate Cell...and this *really* solved what was are real PITA.