page margin

Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database. Then
select the report in the Database window, copy (Ctrl+C), and paste (Ctrl+V),
supplying a new name for the copy of the report. Can you change the margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin of
the copy.

I have another report that is exactly the same but uses a different cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database. Then
select the report in the Database window, copy (Ctrl+C), and paste (Ctrl+V),
supplying a new name for the copy of the report. Can you change the margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database. Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

How do you do step 5 that you referred to in your earlier response. I don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database. Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Sorry for the confusion if I caused any, the step 5 I was referring to was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know what
you mean by "setting minimal references" or how the corrupt report will show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database. Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in the
code window).

Once you are there, you will find References on the Tools menu.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

OK, I was able to get to the Code window before then but I do not know what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process will
cease at step 5 and see the name of the object that did not import. What is
the process that will cease? I was able to import the report whose margin I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in the
code window).

Once you are there, you will find References on the Tools menu.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to 1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import. What
is
the process that will cease? I was able to import the report whose margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as" grayed
out but set on report. Would this be because the report asks for some data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import. What
is
the process that will cease? I was able to import the report whose margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon