fields, columns, reports and a jumbled mess

[Guest]

hi,

i'm having a lot of trouble creating a database on access that will allow me
to have soo many columns (about 20) appear all on one page. ideally i would
like all of the columns to go straight across the page and then return to the
same page and continue below the earlier columns. instead, access continues
the remaining columns on ANOTHER PAGE ENTIRELY. is there any way that i can
adjust the page settings, column settings, fields, or whatever they're called
so that i can have the information pertaining to one particular item appear
on the same page? thanks.

 

[Al Camp]

Knga,
I don't know of any way to do that in Datasheet view.
Create a form, based on your table. Make it a "continuous" form, and
arrange 10 of your fields in row 1 and the next 10 fields in a second row 2
of the detail section.

A simplified example in form design view...
Detail Section--------------------------------
Col1 Col2 Col3 Col4 etc... to 10
Col11 Col12 Col13 Col14 etc... to 20