I really need a grid control to allow me a dynamic number of rows containing data fields and also command buttons and hyperlinks. The grid would be disconnected
from the database.
I have not seen description of this important UI in any of MS Access books. Any suggestions would be appreciated.
I thought of using Excel within my Access app, but decided against it.

Thank you,
Vlad

Hi Vlad (again!)

I had exactly this problem recently. What I wanted to do was to have full control of the background colour of the cells, so a datasheet display was ruled out. I tried all sorts of standard Microsoft OCX components, but since I also wanted to allow data entry, and none of them would allow that, it was back to square one.

What I ended up doing was using continuous forms as a sub-form. From the other posting of yours that I have answered this morning, it looks like you are leaning this way too. Best of luck with it!

Richard

A tad bit late to this party, but I had the same issue.

My resolution was using the Microsoft Office Spreadsheet 11.0 control.

A bit over kill but free. After editting several properties and seting run time parameters, I was able to get a clean data grid-ish looking control.
I only needed read only dynamic data from a datbase so it does what I need it to do with out a $500 license fee from VS Flex grid.

10Tec iGrid ActiveX grid costs almost nothing ($175) but does a lot of things. Consider it if you need a versatile unbound grid. They also have an article about the usage of iGrid in MS Access: http://10tec.com/articles/ms-access-grid-control.aspx