Problems Creating Reports

[Elizabeth]

I need to create several reports containing lists of
items.

If I use the Report Wizard to create the report and view
it, it is fine. As soon as I revise the form to look the
way I want it to, it no longer show the complete list of
items.

If I create the report from scratch, it shows only three
or four items with triple spaces between the items.

One of the reports has a long list that spans several
pages. I want to have two or three columns per page so
the list is shorter.

Can anyone help?

 

[Larry Linson]

I've never seen an Access report that deviated very much from the design,
and when it did (a few versions ago, it was a problem of the difference in
rendering fonts on-screen and by the printer driver -- nothing like triple
spacing).

Unfortunately, it's not possible to "see" what you did in a message in a
newsgroup, and attaching files is strongly discouraged. But, perhaps you
could explain the context in which you are seeing incomplete data. Please
clarify here in the newsgroup, not by e-mail. Thanks.

There are two icons for previewing a report: one is Preview, the other is
Layout Preview -- it's the icon with a page with a little lightning strike
inside the page alongside a magnifying glass. That may limit the data that
you see.

As for the triple spacing, if you close up the section size as close as you
can to the text boxes where the data is displayed, there should not be any
extra spaces... but, if you have space in design view, then there'll be
space between the lines in report view.

Larry Linson
Microsoft Access MVP