creating a grid on a form

[sam1fletcher]

hey all what is the best way to create a grid on a form for example 10x365. is there any other way round it rather than creating 365 fields in a table then creating the corresponding textboxes for them. or can something be drawn then the information of each node be stored in a variable and placed in the table.

Also is there a way where the user can select the sixe of the grid?

Sam

 

[Alansidman]

Have you considered setting your form in Datasheet view? Look in the properties for your form in the format tab. Sounds like you are wanting your form to resemble a spreadsheet?

If you are looking to have 365 fields in your table, it sounds like there might be a normalization issue.

You might want to read this article on normalization
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx