Data Grid Controls for MSACCESS 2000 Development

[WGHayes]

I am researching alternative data grid management to the 'datasheet' view
option available in MSACCESS. I have forms in datasheet view which are
bound to 'temp workfile' tables or 'queries' (Using DAO). Whilst the
'datasheet' view is fine for basic data manipulation where the data is BOUND
I am wanting to access a grid control with additional features (i.e. bound
and UNbound modes, sub totalling and grouping, column sorting, cell
formatting, colours and font management, multi line column titles and
more...)

What I am finding difficult is locating a suitable control that is
compatible with an MSACCESS 2000 container. The controls I have found so
far that look compatible with MSACCESS 2000 are:-

Both of these controls however use ADO (DAO not supported) .

itGrid - <http://www.it-partners.com/products/itGrid/itGrid.asp>

iGrid - <http://www.10tec.com/Products/ActiveX/iGrid/index.aspx>


Questions I have:-

(a) What other 'data grid' controls are there in the marketplace that are
compatible with MSACCESS 2000 containers?

(b) What data grid controls are other developers using and what issues have
they found in using these controls?

(c) Are there any data grid controls that support DAO with the advanced
features that I require?

Thanks.
WGH.

 

[Albert D.Kallal]

most activeX controls will work with ms-access.

Before you make this jump....read on...

take a look at these screen shots..and my point on often you do NOT need a
grid contorl.

Don't use a datasheet view..but use a continues sub-form as shown here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

The above should give you most what you need. It is quite rare with
continues forms that I need a grid contorl..

If you need more..then I would suggest tlist7. I used it with ms-access, and
it quite nice

http://www.bennet-tec.com/btproducts/tlist/tlist.htm
http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm