Strange behavior: Colum disappears in label report

[John]

In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with
the wizzard. The report is based on a temp table that is created when the
user pushes a button. After creation of the table the pushbutton opens the
report.

Now something weird happens. When I open the report manually a few or more
times it remains intact. However, when I open the report from the form's
pushbutton code for the first time, the report will open OK. When I close it
and open the report again (either via the pushbutton or manually), the
second column is missing in the report and all labels are shown only top to
bottom.

So this loss of the column appears to be happening after closing the report
when opened from the pushbutton. The report is opened by DoCmd.Openreport
stRepName, acPreview.

Is this a known issue? Is there a workaround?
Thanks for any insights,
john

[John]

Update: the column now also disappears when opening and closing the form
manually.
Btw: this is Access 2000.
john

"John" <[e-mail] in bericht
news:er***********@textnews.wanadoo.nl...

In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with
the wizzard. The report is based on a temp table that is created when the
user pushes a button. After creation of the table the pushbutton opens the
report.

Now something weird happens. When I open the report manually a few or more
times it remains intact. However, when I open the report from the form's
pushbutton code for the first time, the report will open OK. When I close
it and open the report again (either via the pushbutton or manually), the
second column is missing in the report and all labels are shown only top
to bottom.

So this loss of the column appears to be happening after closing the
report when opened from the pushbutton. The report is opened by
DoCmd.Openreport stRepName, acPreview.

Is this a known issue? Is there a workaround?
Thanks for any insights,
john

[John]

Problem seems to be solved by unchecking apply Auto NameCorrect. Now the
margins remain the same.
john

"John" <[e-mail] in bericht
news:er***********@textnews.wanadoo.nl...

Update: the column now also disappears when opening and closing the form
manually.
Btw: this is Access 2000.
john

"John" <[e-mail] in bericht
news:er***********@textnews.wanadoo.nl...

>In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with
the wizzard. The report is based on a temp table that is created when the
user pushes a button. After creation of the table the pushbutton opens
the report.

Now something weird happens. When I open the report manually a few or
more times it remains intact. However, when I open the report from the
form's pushbutton code for the first time, the report will open OK. When
I close it and open the report again (either via the pushbutton or
manually), the second column is missing in the report and all labels are
shown only top to bottom.

So this loss of the column appears to be happening after closing the
report when opened from the pushbutton. The report is opened by
DoCmd.Openreport stRepName, acPreview.

Is this a known issue? Is there a workaround?
Thanks for any insights,
john

[fredg]

On Sat, 24 Feb 2007 13:01:43 +0100, John wrote:

Update: the column now also disappears when opening and closing the form
manually.
Btw: this is Access 2000.
john

"John" <[e-mail] in bericht
news:er***********@textnews.wanadoo.nl...

>In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with
the wizzard. The report is based on a temp table that is created when the
user pushes a button. After creation of the table the pushbutton opens the
report.

Now something weird happens. When I open the report manually a few or more
times it remains intact. However, when I open the report from the form's
pushbutton code for the first time, the report will open OK. When I close
it and open the report again (either via the pushbutton or manually), the
second column is missing in the report and all labels are shown only top
to bottom.

So this loss of the column appears to be happening after closing the
report when opened from the pushbutton. The report is opened by
DoCmd.Openreport stRepName, acPreview.

Is this a known issue? Is there a workaround?
Thanks for any insights,
john

If you are using Access 2000 this is a known bug and is documented in
the Microsoft Knowledgebase article:
Q245021 'List of Fixed Problems in Microsoft Office 2000 Service
Release 1/1a (SR-1/SR-1a)'
And specifically:
Q240826 'Lost Printer Settings when Name Autocorrect is turned on'

Turn off the Name AutoCorrect feature as a temporary 'fix'.
Then download and install the Service Release 1/1a.

Even if you are not using Access 2000, turn off the Name AutoCorrect.
Tools + Options + General Tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail