Expanding Length of Form

[Sorting in a Graph]

Current form only allows 22 inched in width. How can I expand/increase this
length?

 

[Beetle]

AFAIK you can't, and why would you want to? A form this wide would mean
your users would have to do a whole lot of scrolling back and forth, which IMO
would get old really fast.

 

[Sorting in a Graph]

I have a table with many columns and can not get them all on a form that is
set up by rows. Any suggestions on how to handle the additional columns.

 

[Golfinray]

I think it would be better to use part of the data at a time. Set up a
mainfrom and subforms (use the subform wizard, it will do it for you) and
then you can get more infor on the page. Put 4 or 5 columns in each subform
and link them to the mainform where they all change at once.

 

[Beetle]

If you have so many columns in your table that they won't fit on a 22"
wide form, then I think it is more likely that you have a table design
issue rather than a form design issue. Either that, or you are making
your form controls unusually wide for some reason. It is very unusual
to need a table with more than 25 fields or so and a table with more
than 50 is almost certainly wrong.

Is all the data in your db stored in one large table?

 

[John W. Vinson]

I have a table with many columns and can not get them all on a form that is
set up by rows. Any suggestions on how to handle the additional columns.

If you have more than 25 or 30 fields (they're called fields, not columns
usually) in a table - then your table is almost certainly misdesigned. Access
is NOT A SPREADSHEET, even though a table might look like one!

What are some of these fields? What is the nature of the data you are storing?
I very strongly suspect that you have a one-to-many or many-to-many
relationship embedded within each record, and that normalizing your data will
be a far better solution than tweaking your form.