Access Compatible Grid Controls

(Updated 2010-09-27)

Why?

Why would you need a grid control?  After all Access's own subforms or continuous forms are very useful, aren't they?

A2000 and newer do support conditional formatting but one major, in my not so humble opinion, is different lists in combo boxes in different records.   For example lets take a list of components for a computer.  You add a new record and choose CD/DVD readers as a category.  Wouldn't it be nice to then see in the combo box just a list of CD/DVD readers.

Or suppose that some lines require an additional size, ie RAM or hard drive size, but others don't, ie CD/DVD.  It would be nice to turn on or off that specific field for that specific record.

Links

• Gridwiz
• Janus GridEX 2000 (A member of a local user group has stated that he is quite happy with this control  and has had rapid response to his emails and bug fixes)
• TList  
• ctGrid (was Grid Tools)
• XpressQuantumGrid
• Objective Grid (Part of the Stingray product)
• Exontrol ExGrid
• iGrid Control
• Sample code for MS Flex Grid  > Downloads. Samples of how it looks in production can be seen at www.RetreatTracker.com > Samples > Building Schedules  (You must ensure you own a product which allows you to legally redistribute this control.)

When reviewing these or any other controls ensure the vendor specifically states that they do support Access with their controls. In which case they will likely also have sample code on their website. Frequently VB code can be reviewed and adapted.  Most of the vendors who sell control allow you to download a demo version and see if it suits your needs. For more details on why many ActiveX controls don't work in side Access see the following Knowledge Base articles at support.microsoft.com.

ACC97: Custom ActiveX Control Features Supported in MS Access 97
ACC97: ActiveX Controls List Doesn't Show All ActiveX Controls
ACC2000: Custom ActiveX Control Features Supported in Access

[ Third party | Access | Main ]

   Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks.

Granite Fleet Manager - the best designed fleet maintenance tracking and management system available