Build a display table on a form. On the fly.

[stappawho]

Hello,

I am trying to put together a form that will take a record and do some math to build a table. I don't know access very well (I do web programming) so I'm not sure how to best go about.

I need to build something like this.

But there is something like 8 columns. Is there a control to make a nice formated table like this? Is it possible to build an HTML table in a label or something? It's going to be anywhere from 10 - 20 rows and 8 or so columns. The info for the cells is just calculated on the fly for each individual record. I know how to do all the calculations and what not, I just don't know how to do the formatting in access.

Thanks.


edit.............

Also, when creating a columner form with the form wizard is there a way to get control of the arrow buttons? Or at least track the action. Or do I have to do it by txtID.OnChange event? Also, when doing a form with the form wizard how do I update the current record by a search? An example would be the user enters in the ID of the record they want to view and the columner form jumps to that record. And is there a way to sort the results of a columner form created with the form wizard?