Hey,
I have to create a series of subforms that are used to display information that is currently stored in spreadsheets. This is ok, as for a couple I have simply created a series of text boxes and bound them to a table.
My issue is that some of the spreadsheets contain upto 200 columns, which makes the above process a little annoying, not to mention massive. The other issue is that a lot of the fields will be blank, and the column names vary in size from 3 letters to 6 words.
Does anyone know of a more efficent and effective way of displaying all this information.
Cheers,
Matt
I have to create a series of subforms that are used to display information that is currently stored in spreadsheets. This is ok, as for a couple I have simply created a series of text boxes and bound them to a table.
My issue is that some of the spreadsheets contain upto 200 columns, which makes the above process a little annoying, not to mention massive. The other issue is that a lot of the fields will be blank, and the column names vary in size from 3 letters to 6 words.
Does anyone know of a more efficent and effective way of displaying all this information.
Cheers,
Matt
