I cant get my report to fit on one page

The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of the
shading but none of the data or headings on the second page

How wide is the report (i.e.: the Width property of the Report object). If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you need to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of the
shading but none of the data or headings on the second page

didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report object). If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you need to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of the
shading but none of the data or headings on the second page

That implies you've got something (possibly a line) that extends too far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of
the
shading but none of the data or headings on the second page

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of
the
shading but none of the data or headings on the second page

why do i get the first header group shown as blank, there isnt any blank data
in the
database?
"rmoritzky" wrote:

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little of
the
shading but none of the data or headings on the second page

Is there anything in the Detail section associated with that header?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
why do i get the first header group shown as blank, there isnt any blank
data
in the
database?
"rmoritzky" wrote:

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too
far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report
object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you
need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little
of
the
shading but none of the data or headings on the second page

I dont know what you mean by associated... data in the detail section that
also appears in the header?

"Douglas J. Steele" wrote:

Is there anything in the Detail section associated with that header?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
why do i get the first header group shown as blank, there isnt any blank
data
in the
database?
"rmoritzky" wrote:

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too
far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report
object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide), you
need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a little
of
the
shading but none of the data or headings on the second page

Presumably you've got

Header 1
detail for header 1
detail for header 1
detail for header 1
Header 2
detail for header 2
detail for header 2
Header 3

and so on.

Is there a detail section associated with the empty header?

If so, that implies that there are rows with blank for whatever field(s)
make up the header.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
I dont know what you mean by associated... data in the detail section that
also appears in the header?

"Douglas J. Steele" wrote:

Is there anything in the Detail section associated with that header?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
why do i get the first header group shown as blank, there isnt any
blank
data
in the
database?
"rmoritzky" wrote:

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too
far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report
object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide),
you
need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in
message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a
little
of
the
shading but none of the data or headings on the second page

my report headings dont print except on the first page, there is no detail
under that first header... i tried to put in a page break where one of the
headers was but it was sloppy, i mean it worked sorta, i found the page break
descriptions in reports in access almost incomprehensible

What I got was this:

Page heading

Header 1
No Detail

Header 2 (on new page when i inserted a page break here) NO PAGE HEADING
Detail
Detail
Detail

Header 3 (on new page when i inserted a page break here) NO PAGE HEADING
Detail
Detail

really appreciate your help here
robert

"Douglas J. Steele" wrote:

Presumably you've got

Header 1
detail for header 1
detail for header 1
detail for header 1
Header 2
detail for header 2
detail for header 2
Header 3

and so on.

Is there a detail section associated with the empty header?

If so, that implies that there are rows with blank for whatever field(s)
make up the header.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
I dont know what you mean by associated... data in the detail section that
also appears in the header?

"Douglas J. Steele" wrote:

Is there anything in the Detail section associated with that header?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
why do i get the first header group shown as blank, there isnt any
blank
data
in the
database?
"rmoritzky" wrote:

ya know what? i had a bunch of em! (lines) thanks for your help

"Douglas J. Steele" wrote:

That implies you've got something (possibly a line) that extends too
far to
the right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in message
...
didnt know what it was til now but
when i try to change it it just pops back to what it was

"Douglas J. Steele" wrote:

How wide is the report (i.e.: the Width property of the Report
object).
If
it's greater than 7 1/2" (assuming your paper is 8 1/2" wide),
you
need
to
make it narrower.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"rmoritzky" wrote in
message
...
The report is profile inpage set up

I have reset the margins to 1/2 " in page set up

The first page of the report goes to two pages, with just a
little
of
the
shading but none of the data or headings on the second page