AutoCorrectName Problems

[DS]

I think AutoCorrectName is messing with my report margins. I turned it
off, but stll I get a hard marging on the right of 1". I'm using Access
2002 Version 10.2616.2625
Any help appreciated!
Thanks
DS

 

[Jeff Boyce]

The messing may be embedded.

Have you tried re-building the report from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DS]

The messing may be embedded.

Have you tried re-building the report from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes, rebuilt the entire report from scratch and i'm stuck with a 1 inch
margin on the right, the left is fine. i even downloaded sp3. still
can't get it to work...getting desperate!
thanks
ds

 

[DS]

yes, rebuilt the entire report from scratch and i'm stuck with a 1 inch
margin on the right, the left is fine. i even downloaded sp3. still
can't get it to work...getting desperate!
thanks
ds

Ok I tried another report and it printed at the correct margin but I got
a mess. Instead of...
1 Sunday
2 Monday
3 Tuesday

I got

S 1unday
M 2onday
T 3uesday


Help!!!!
Thanks
DS

 

[Jeff Boyce]

Without more descriptive explanation, it will be hard to offer specific
suggestions...

Your example:

Instead of...
1 Sunday
2 Monday
3 Tuesday

I got

S 1unday
M 2onday
T 3uesday

causes me to wonder if you are working with one control (day of week) or
two?

Can you confirm that the underlying query is generating the correct results?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Allen Browne]

PMFJI, but a couple of suggestsions, here, DS.

1. Go to:
http://support.microsoft.com/sp
and download the updates for Office XP.
You should have SP3 (or at least SP2.)

While you are there, get the JET 4 update:
http://support.microsoft.com/kb/239114

2. This really sounds like a problem with the printer driver.
The unprintable area of the printer can affect the report's margin settings,
and now it turns out that it is placing the text boxes wrongly as well.
Access uses the driver metrics to calculate the layout of the report, so it
sounds like the driver is providing faulty metrics.

Go to the manufacturer's site, and see if you can download a more recent
driver for the printer.

Hopefully you have compacted the database since you unchecked the Name
AutoCorrect boxes under:
Tools | Options | General.

 

[DS]

Without more descriptive explanation, it will be hard to offer specific
suggestions...

Your example:




causes me to wonder if you are working with one control (day of week) or
two?

Can you confirm that the underlying query is generating the correct results?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yeah the query is good and I do have 2 fields. I'm getting the right
results, Now I can't even duplicate it.
Thanks
DS

 

[DS]

PMFJI, but a couple of suggestsions, here, DS.

1. Go to:
http://support.microsoft.com/sp
and download the updates for Office XP.
You should have SP3 (or at least SP2.)

While you are there, get the JET 4 update:
http://support.microsoft.com/kb/239114

2. This really sounds like a problem with the printer driver.
The unprintable area of the printer can affect the report's margin
settings, and now it turns out that it is placing the text boxes wrongly
as well. Access uses the driver metrics to calculate the layout of the
report, so it sounds like the driver is providing faulty metrics.

Go to the manufacturer's site, and see if you can download a more recent
driver for the printer.

Hopefully you have compacted the database since you unchecked the Name
AutoCorrect boxes under:
Tools | Options | General.

I'm using a Generic Text Driver with an Epson Tmt88iii printer.
Also have service pack 3
Using officeXP with Access 2002 file format is access 2000.
Does this change anything? Do I need to go to Access 2002 fle format?
Thanks
DS

 

[Allen Browne]

Any chance of getting a more specific printer driver?
Or even trying it out with a completely different printer?
If that solved the problem, it would at least verify the cause of the
problem.

Changing to the Access 2002 file format will not make any difference.

In your original post, you referred to Access 2002 Version 10.2616.2625.
Unless you have made some changes since then, you don't have SP3.

 

[DS]

Any chance of getting a more specific printer driver?
Or even trying it out with a completely different printer?
If that solved the problem, it would at least verify the cause of the
problem.

Changing to the Access 2002 file format will not make any difference.

In your original post, you referred to Access 2002 Version 10.2616.2625.
Unless you have made some changes since then, you don't have SP3.

Thanks Allen, I've since upgraded to SP3. I've tried the Epson Driver
but that takes 5 Seconds until it starts to print.
Thanks
DS