dynamically creating a grid with text boxes in access like a table in excel

[xuxa]

I want to create a grid dynamically which contains text boxes in access. The number of columns and the row in the grid will also be created dynamically based on the value entered by the user. So if you imagine a table in excel or word that has rows and columns I want to replicate the same in access. I am not sure what is the best way to do it. And i then need to save all the data entered by the users in those text boxes in the database. Please help.

[pbaldy]

Generally not done. For one thing, there's a limit to how many controls can be added to a form over its life, and deleting them doesn't reset that. Secondly, if you give users an mde/accde or they have the runtime version of Access, I don't think they can change the design of the form, even via code (I could be wrong on the last bit).

Perhaps if you give us an idea of what you're trying to accomplish, we can give other ideas. One is to use a continuous or datasheet form or subform that will grow dynamically to accept however many records the user wants to add.