Can anyone recommend a data grid control that can connect to an ADO recordset? For use with VB6 and MsAccess 2000 VBA.
(Or a suite of programmable tools that includes a grid for editing database tables)
Some features I need:
1. Unicode
2. Custom controls (For example, checkboxes, images/icons)
3. Allow user to move columns, resize columns, maybe hide/show columns
4. Can handle large amounts of data (100,000 to 1Million records)
5. Editable (+ options to make some columns read-only)
6. Programmable (esp. can trap when user clicks on a field, trap "On Update", "Before Edit", etc.)
If you've used some controls and can recommend some, or know a site where they are compared, please let me know. (And include what you like and dislike about the control).
My findings so far...
Microsoft's DataGrid: (#2 and #6 are difficult--any hints?)
Express Quantum Grid: good except for #1:Unicode
Start Free Trial
