A single row has too much info for the screen.

  • Thread starter Thread starter LAS
  • Start date Start date
L

LAS

Is there a way to scroll a single row up and down within the detail space of
a form? My table has too much info to squeeze it all into the space of the
screen.

TIA
LAS
 
Is there a way to scroll a single row up and down within the detail space of
a form? My table has too much info to squeeze it all into the space of the
screen.

TIA
LAS
Click to expand...

Then your table is misdesigned, I fear! How many fields? How big are the text
fields? You're limited to 255 fields and 2000 bytes actually occupied in each
record (exclusive of Memo fields).

That said... sure, you can make your form up to 22" by 22", and put up to 937
(or some such number) controls on it, and use scrollbars to navigate
vertically and horizontally. If you do so you're at great risk of being
lynched by your users though...

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
How do I use a scroll bar to navigate up and down through a record on a
continuous form? I don't think it was appearing when a single record was
just to tall. If the expected behavior is that it would appear, I'll try
again.
 
How do I use a scroll bar to navigate up and down through a record on a
continuous form? I don't think it was appearing when a single record was
just to tall. If the expected behavior is that it would appear, I'll try
again.
Click to expand...

Sorry, I misunderstood: no you can't scrollbar through a single record.

But you CAN make a single record that is two controls high, or three, or ten.
You'll see fewer records on screen but more data for each record.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Are you absolutely committed to having everything on the one continuous
forms view? If not, then use the abbreviated view on the continuous form
with double-click event to open a full-detail, single form view, of that
record...

In the double click event, use DoCmd.Open Form, with the key field from the
active record of the continuous form, to open a single record form. If you
want to require the user to take some action on that form, you can specify
it as a popup or modal, so the user will have to act or dismiss it
purposely.
 
Back
Top