MS Datagrid ActiveX with MS Access 2016

Question

Hi,

Is there a way we can use MS Data grid.ocx in MS Access form?

I don't see option to add ActiveX like it was in MS Access 2000 (right click in ActiveX control to add other ActiveX control...)!

I have tried to add from c:\Windows\SysWOW64\MSDATGRD.OCX in VB Reference but still not showing in ActiveX control list when trying to add control on MS Access form!

Thanks

Answer 1

Somebody may correct me if I am wrong, but I believe the Datagrid.ocx active x control is is used in .Net applications, and will not work in Access.

Hope this helps

Alan

Answer 2

For one application I am using MsFlxGrd.ocx just fine in latest version of Access.

Answer 3

Are you sure you really need to use the datagrid control?

Access has what is called “continues” forms (or often called multiple item forms).

They tend to be as good, or better than that .net datagrid.

They tend to produce great results and with far less effort then the .net version.

They allow buttons, check boxes, and even combo boxes.

You get to write standard VBA for the buttons, or whatever control you place on the continues form.

They can be bound directly to a table, or query – no code required to do this and that means the grid display will edit data for you, and do so without having to write even one line of code.

So, you can make a form like this:

 

And even better, is this feature is built right into access.

Continues forms have near un-limited layout possibilities, such as above, or even this:

Or this:

 

Or this:

All of the above screens where 100% access, and no special coding or even layout skills were required (just plain Jane access).

You could still perhaps use and get that datagrid control working. (do a regsvr32.exe on that ocx control - it should then appear as a activeX control for use from Access.

With the continues form option built right into access, it rather hard to make the case to use some external data grid, when access has one of best grid tools available that is built right in.

You should be able to get that .ocx registered for use with Access, but consider using the built in "grid" ability of Access if possible.

Regards,

Albert D. Kallal (Access MVP 2003-2017)

Edmonton, Alberta Canada

Answer 4

In later versions of Access, the ActiveX controls are found on Form Design Tools - Design - Controls section. Click the down arrow and you'll see this:

That said, I agree with Albert - if you can use native Access objects to do what you want, then you're far better off doing that. And, the grid control you reference is NOT one that generally will work with Access (and even if it works on your system, it may not work on others). The FlexGrid generally does work with Access, but as with an ActiveX control, you're better off staying away from it (at least in Access).