By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,602 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

Strange behavior: Colum disappears in label report

P: n/a
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
Feb 24 '07 #1
Share this Question
Share on Google+
3 Replies


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

"John" <jo@hn.comschreef 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

Feb 24 '07 #2

P: n/a
Problem seems to be solved by unchecking apply Auto NameCorrect. Now the
margins remain the same.
john

"John" <jo@hn.comschreef 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" <jo@hn.comschreef 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


Feb 24 '07 #3

P: n/a
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" <jo@hn.comschreef 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
Feb 24 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.