Printing Problem

23 Aug 2006 2:03 PM

Billy

While printing, I am getting more pages than is expected. If I select a
particular record to print, 4 pages show. I would like to have these
in one page. I looked at the datasheet and there are about 4
subdatasheets. I am assuming that they are pulling from different
tables.
Can somebody please help?
Billy

23 Aug 2006 4:39 PM

Joan Wild

One doesn't usually print a datasheet (whether that is a table, query or
form). Create a report and use that for printing.

--
Joan Wild
Microsoft Access MVP

Billy wrote:

Show quoteHide quote

> While printing, I am getting more pages than is expected. If I select
> a particular record to print, 4 pages show. I would like to have
> these in one page. I looked at the datasheet and there are about 4
> subdatasheets. I am assuming that they are pulling from different
> tables.
> Can somebody please help?
> Billy

23 Aug 2006 5:11 PM

Billy

Thanks Joan,
Yes, I am printing from the report that is pulling from some tables.
The forms where data is entered also has subforms. I have tried
changing a few things on the properties like "Can Grow" or "Can
Shrink".
HTH
Billy
Joan Wild wrote:
Show quoteHide quote

> One doesn't usually print a datasheet (whether that is a table, query or
> form). Create a report and use that for printing.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Billy wrote:
> > While printing, I am getting more pages than is expected. If I select
> > a particular record to print, 4 pages show. I would like to have
> > these in one page. I looked at the datasheet and there are about 4
> > subdatasheets. I am assuming that they are pulling from different
> > tables.
> > Can somebody please help?
> > Billy

23 Aug 2006 9:17 PM

Joan Wild

Your forms really don't have anything to do with this.

You've created a report to print what you like (just don't bother with the
related table's data if you don't want it). You could also use sub-reports
if you like.

--
Joan Wild
Microsoft Access MVP

Billy wrote:

Show quoteHide quote

> Thanks Joan,
> Yes, I am printing from the report that is pulling from some tables.
> The forms where data is entered also has subforms. I have tried
> changing a few things on the properties like "Can Grow" or "Can
> Shrink".
> HTH
> Billy
> Joan Wild wrote:
>> One doesn't usually print a datasheet (whether that is a table,
>> query or form). Create a report and use that for printing.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Billy wrote:
>>> While printing, I am getting more pages than is expected. If I
>>> select a particular record to print, 4 pages show. I would like to
>>> have these in one page. I looked at the datasheet and there are
>>> about 4 subdatasheets. I am assuming that they are pulling from
>>> different tables.
>>> Can somebody please help?
>>> Billy