View Single Post
  #2  
Old June 7th, 2010, 03:22 PM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default PageSetup properties keep changing

Make sure Name AutoCorrect is turned off.
Then compact the database.
Explanation:
http://allenbrowne.com/bug-03.html

If this is Access 2007, make sure you have applied the service packs. SP2 is
he
http://www.microsoft.com/downloads/d...displaylang=en

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"PayeDoc" wrote in message
...
Hello All

I recently had some mdb corruption problems, that I THINK I've solved - by
creating a new mdb and importing all objects. A new problem has now
started
that is either coincidental or is somehow related to my having done the
mdb
rebuild.

The page setup properties of various reports changes, periodically, 'by
iteslf'! I have been able to repeat this behaviour to some extent:

1. preview report - discover that the page setup properties are completely
wrong
2. close the report
3. select the report in the main database window, go FilePage Setup,
correct the properties
4. preview report - the page setup properties are now ok
5. close the report
6. amend a parameter on the open form that is used by the report
7. preview report - discover that the page setup properties are completely
wrong again!

This doesn't always happen, and I have been unable to identify any
pattern.
The page setup properties are the margins, the landscape/portrait setting,
and in one case the printer - changed from 'specified printer (correct) to
default printer (not corect). I had been advised that setting the page
setup
properties from the File menu item in the main database window was more
reliable than setting them from the report's design view - hence step 3
above.

Can anyone shed any light on this?

Thanks for any help.
Leslie Isaacs