AutoCorrectName Problems

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
The messing may be embedded.

Have you tried re-building the report from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff said:
The messing may be embedded.

Have you tried re-building the report from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
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 said:
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
Click to expand...
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
 
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
Click to expand...

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
 
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.
 
Jeff said:
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
Click to expand...
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
 
Allen said:
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.
Click to expand...
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
 
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.
 
Allen said:
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.
Click to expand...
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
 
Back
Top