Trim items

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I have a report that list a Box # and the items listed
that are within the box. For ex: Box #1, may have, Item
A, Item B, Item C, Item D and Item F. While box #2, may
only have item A and item B. Is there a way maybe
using "Trim" or some other formula that I can list all 5
items in a column or only 2 items in a column without
leaving extra lines for the fields where there are no
items? Ex:

Box 1 Item A
Item B
Item C
Item D
Item F

Box 2 Item A
Item B
_End of Report__________________________

Can someone please point me in the right direction.
Aurora
 
Try making a subreport to hold the Items information.
Then, you will only get as many lines as there are Items.
 
THANK YOU FOR ANSWERING! I did what you suggest (I should
have thought of this myself). I have done this type of
form and printed one page reports before without any
problem. But now I am trying to print 4 labels on one
page. I could do this before with just the one Db holding
all the information, but I am having trouble trying to do
this with the subform or 2 databases.

I have the dbs linked by the Box number and the page setup
set to 2 columns and 2 rows. But the form is going all
over the page. The heading is in the Left hand corner and
down a couple of inches is one line of contents, and
accross the page is the 2nd line of contents and then back
to the left side is the 3rd line of contents. I know I
must be doing something stupid, but for the life of me
can't figure out what. Do you have any suggestions?

Aurora
 
Just a few things to check - Report/page headers/footers
will span the entire page. Group headers/footers will
print within boundaries of columns.

Page setup - 2 columns sounds right. Not sure about the
rows set to 2. I think that means skip 2" between each
group. Also, you can set the column width and height.
Make sure your data fits within these limits.
 
Thank you for answering. I had to put everthing in the
Detail section to get it to print 4 labels on the page.
But it is still only printing one line of contents, then
goes to the right and prints the label with the 2nd line
of contents and back to the left side with the 3 line of
contents. All my label settings are the same as when I
used one Db - Which printed the labels out beautifylly.

Do you have any other ideas?

Aurora
 
Back
Top