Reports- page setup changes

[Thom]

I am using Access 2000 and when printing reports, the page setup changes of it's own accord. Not just reverting to Imperial measurements, but a 'new' page dimension - especially when the report contains columns. I have been told this is a known Access bug but have not been able to track it down via the MS Knowledge base query. (Very frustrating/embarrasing on a client site at delivery time.)
Thanks in anticipation...

Tom

 

[dawnd3]

I have had LOTS of experience with this and it is a pain This is a bug that has to do with the name autocorrect feature in the options. (don't ask, I know it is a strange connection). You have to go to Microsoft.com and download the SR-1 and SR-2 updates. I think it is SR-1 that fixes that bug. Just go to the knowledge base and look it up. Or give me a minute and I will find it and post again. Dawn

http://www.calliopeconsulting.net

 

[dawnd3]

Here ya go Thom....You can also work around this issue by going to Tools, options and turning off the Name Auto correct. However, I have found that it still happens sometimes.

good luck!

http://support.microsoft.com/suppor...port&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

http://www.calliopeconsulting.net

 

[Thom]

Thanks Dawn,
Will hunt that down and thank-you once again
Thom

 

[AutumnBlues]

Have you tried the Docmd.Bibble command.
I've used it with varying degrees of success.

Alternatively, you may want to invoke the 'scroll lock' procedure (scroll lock is the button whose sole purpose is to light up the scroll lock light) and run through your routines with the scroll lock light on and off.

Other than that, the only thing that I can suggest is that you eat a few of the function keys (but avoid F8).

Good Luck
Mugwump

 

[dawnd3]

Mugwump, are you responding to this post or another by accident?

Dawn

http://www.calliopeconsulting.net