Three Dimensional Data Array Grid and Report Viewer

The module shows how to use a three deminsional array to store, read and display column widths, row heights and data. For the sake of simplicity, I loaded static data of fixed rows and heights in the form load event, but a user interface could be created to dynamically store varying widths and heights.

I included a procedure for determining which corresponding cell the mouse is over and displaying the data from that cell in the form caption. This is a dynamic procedure that will adjust to varying cell widths and heights.

Again, the GetRowCol procedure is encapsulated and easily portable to a project or bas file. Included is a report viewer, save capability and print preview .