vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Home Contact Us
Order our Software

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed More..

DryToast New
Backup and query your BaseCamp® projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our Aussie
vb123.com.au
mirror site

Page Formatting Bug In Access 2000

By Owen Jenkins

I've found an Access 2000 bug. I haven't used 2000 much so maybe this is old news. If you copy a file, parts of the report formatting reverts to default values. This happens with page margins etc and drove me mad for a couple of hours. It's to do with the Name Autocorrect functions.

If you format a report with specific margins and portrait/landscape etc, then modify the db, the page formatting reverts to the default. I found a bit of detail about it in the MS KB article Q240826. Click on the following link to view it.

http://support.microsoft.com/support/kb/articles/Q240/8/26.ASP

The format reverts to the default if the table design the report is based upon is modified. There are two other scenarios - a report with a subreport and a modified query name.

The fix includes.

Set the Name Autocorrect off, or install SR1. In any case, any user with A2000 without SR1 should have Name Autocorrect set to off. Perhaps the update should do this automatically.

For all your health and research-related Access needs.

Contact Owen Jenkins from http://www.healthbase.com.au