By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Datasheets are too long

P: 3
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?
Jan 15 '07 #1
Share this Question
Share on Google+
9 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Jan 16 '07 #2

ADezii
Expert 5K+
P: 8,597
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.
Jan 16 '07 #3

Expert 5K+
P: 8,435
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?
Jan 16 '07 #4

nico5038
Expert 2.5K+
P: 3,072
Why not add a tabcontrol ?

Nic;o)
Jan 16 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
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.
Jan 16 '07 #6

P: 3
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?
Jan 16 '07 #7

NeoPa
Expert Mod 15k+
P: 31,186
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?
Jan 16 '07 #8

P: 3
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.
Jan 16 '07 #9

NeoPa
Expert Mod 15k+
P: 31,186
Do I take that to mean you've added the controls on SubForms inside your various Pages (Tabs)?
Jan 16 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.