Datasheets are too long

[gdit]

I have a datasheet within a subform in an Access database. I have to make the forms fairly small so that they can be viewed on laptop screens. I'm trying to get all the different fields to appear on the screen without someone having to scroll over to enter more data. Is there a way to create a datasheet on multiple rows? I guess I'd like to be able to split up a datasheet so that everything can be seen all at once. I know you can make a form but it's a pain to move the MANY fields that I have to work with and it still might not fit properly. Any suggestions?

[NeoPa]

If I understand the question then certainly there is.
You just position the controls anywhere in the Detail section you want. You control how wide and how high that section is, so how many controls will fit on.

[ADezii]

I have a datasheet within a subform in an Access database. I have to make the forms fairly small so that they can be viewed on laptop screens. I'm trying to get all the different fields to appear on the screen without someone having to scroll over to enter more data. Is there a way to create a datasheet on multiple rows? I guess I'd like to be able to split up a datasheet so that everything can be seen all at once. I know you can make a form but it's a pain to move the MANY fields that I have to work with and it still might not fit properly. Any suggestions?

You can also try working with a higher Screen Resolution if possible. That will give you more real estate to work with.

[Killer42]

If I understand the question then certainly there is.
You just position the controls anywhere in the Detail section you want. You control how wide and how high that section is, so how many controls will fit on.

But wouldn't that be on a form, which the OP didn't want to use?

[nico5038]

Why not add a tabcontrol ?

Nic;o)

[NeoPa]

If I understand the question then certainly there is.
You just position the controls anywhere in the Detail section you want. You control how wide and how high that section is, so how many controls will fit on.

But wouldn't that be on a form, which the OP didn't want to use?

If you read the original post, you'll see that's fairly ambiguous. He starts off using a subform that he wants help with.

[gdit]

Actually, I'm using tabs now. I have about 10 different tabs to work with and at least 5 of the datasheets extend beyond usable area. I tried splitting the datasheets up by using multiple queries but then the user would have to save each line separately and i don't think they'd remember to do that...plus it's a hassle. Thanks for the responses. Any other suggestions on how to organize large amounts of data for small screens?

[NeoPa]

Only by scrolling which I think you've already considered.
Essentially, you can't fit a quart in a pint pot.
Pages (tabs) may help you though, sounds like you've already gone there too. Wouldn't all be visible at once but remind me why that's not a usable solution?

[gdit]

It works as a solution. I'm just trying to help out the people who enter the data over and over. Scrolling can cause confusion, you lose your place sometimes and it slows you down drastically. I guess I just wish I could put the long datasheet on multiple rows so that it all appears at the same time. I was trying to find something so that I didn't have to go edit a ton of forms so that they would fit.

[NeoPa]

Do I take that to mean you've added the controls on SubForms inside your various Pages (Tabs)?