Access 2000 First record of report preceeded by blank record

[Bob]

Hi,
I am using Access 2000 to print out an address book. I have designed
the report based on a database whose first record is not blank. In the
design there is a one line report header, a onle line page header,
three lines of detail (name address etc)and a footer.
On previewing or printing the report it inserts a blank three line
detail section before the first record. Every other page is fine
except this first page. Not a big deal but it send the book into an
extra page at the end that could be avoided if it printed correctly.
Any ideas? Thanks Bob

[Larry Linson]

Re: Access 2000 First record of report preceeded by blank record

I haven't seen this phenomenon. I'm sure you've checked to make certain
there isn't blank space after any Controls in the Report Header or Page
Header. If there's not, and there's not extra space before the Controls in
the Detail Section, I don't know where to tell you to look next.

Maybe someone here would have suggestions if you would copy the SQL for the
RecordSource of the Report and paste it into a followup message.

Larry Linson
Microsoft Access MVP

"Bob" <lrstunell@r3in teractive.com> wrote in message
news:8a8abe39.0 310272112.78557 b90@posting.goo gle.com...[color=blue]
> Hi,
> I am using Access 2000 to print out an address book. I have designed
> the report based on a database whose first record is not blank. In the
> design there is a one line report header, a onle line page header,
> three lines of detail (name address etc)and a footer.
> On previewing or printing the report it inserts a blank three line
> detail section before the first record. Every other page is fine
> except this first page. Not a big deal but it send the book into an
> extra page at the end that could be avoided if it printed correctly.
> Any ideas? Thanks Bob[/color]

[MGFoster]

Re: Access 2000 First record of report preceeded by blank record

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


There may not be a blank record in the result set, but there may be
NULL fields in the report's sort fields (NULL fields sort (ascending)
to the top of a query's result set. Run the query that supplies the
report. Is there a record with NULL, or empty strings, in the fields
you are placing in the report's detail section?

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP57M94echKq OuFEgEQJXfgCgz0 9blCVb983ZTI4Pp JPdDuZ+42EAnilD
kmOD1HDSDkjJxyo V1gKOf29H
=5LuD
-----END PGP SIGNATURE-----

Bob wrote:[color=blue]
> Hi,
> I am using Access 2000 to print out an address book. I have designed
> the report based on a database whose first record is not blank. In the
> design there is a one line report header, a onle line page header,
> three lines of detail (name address etc)and a footer.
> On previewing or printing the report it inserts a blank three line
> detail section before the first record. Every other page is fine
> except this first page. Not a big deal but it send the book into an
> extra page at the end that could be avoided if it printed correctly.
> Any ideas? Thanks Bob[/color]

[Bob]

Re: Access 2000 First record of report preceeded by blank record


Hi Larry,
Thanks for your help. I have now solved the problem - not directly from
the replies but from a clue I got from them. I had linked the table to
an Excel sheet and found one blank record at the bottom of the linked
table. I had assumed that because the other records were in alpha sort
order that the report process just printed it out without any further
sorting. But as this was not so, this record was moved from the bottom
to top during the report generation process. I tried to remove the blank
record but Access would not allow me to do this in a linked table. Then
I went back to the excel sheet but all the lines after this are blank so
removing one would not achieve anything. So I imported the table,
instead of linking to it, and was then able to remove the offending
blank record. Voila! The print out was perfect. I suppose there are
other (better) ways of doing it - but at least this worked.
Thanks again.
Cheers
Bob



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob]

Re: Access 2000 First record of report preceeded by blank record

Hi,
I have solved the problem - not directly from the replies but from a
clue I got from them. I had linked the table to an Excel sheet and found
one blank record at the bottom of the linked table. I had assumed that
because the other records were in alpha sort order that the report
process just printed it out without any further sorting. But as this was
not so, this record was moved from the bottom to top during the report
generation process. I tried to remove the blank record but Access would
not allow me to do this in a linked table. Then I went back to the excel
sheet but all the lines after this are blank so removing one would not
achieve anything. So I imported the table, instead of linking to it, and
was then able to remove the offending blank record. Voila! The print out
was perfect. I suppose there are other (better) ways of doing it - but
at least this worked.
Thanks again.
Cheers
Bob




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Mitchell]

Re: Access 2000 First record of report preceeded by blank record

I may be barking up the wrong tree, please forgive me if I am but in
Access 97 I have a similiar problem. I think it is caused by (or has
something to do with) default values as one of my fields defaults to
zero and the line on both the report and the query which is blank has
a zero in this field. ?!?