Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform in datasheet view problem

Status
Not open for further replies.

upplepop

IS-IT--Management
Joined
Jun 1, 2002
Messages
173
Location
US
Okay, this may be a little hard to explain.
I have a Sub Form that I wanted to put in Datasheet View (instead of Form View) so it could display multiple records in row/column format. However, in that Sub Form, I have a memo field so people can put long descriptions in. However, the sub Form only allows me to put in about 60 characters before they continue off the screen. It has a horizontal scroll bar, but it doesn't move past the 60 characters. How can I get it to display more than 60 characters in the last column while still allowing me to keep a row/column format to view multiple records.

The scroll bar stops before the end of the Description column. I dunno, try making a Sub Form Data Sheet view with 4-5 columns and have a long description in the last column and see what I mean.

Thanks for your help (if you can figure out my problem :)




 
Hi Upplepop:

It just might be that the datasheet view is inappropriate for the records you keep.

Why not design a form that can display all the fields side by side across the screen in one line and then the memo field below them. You could still have continuous records displayed, but fewer visible at one time.

I think your handle is great. Gus Brunston [glasses] An old PICKer, using Access2000.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top