Margins and paper tray settings won't stick!

[TLowell]

This is a problem which has been discusssed before in this forum, but so far the suggestions offered haven't worked.

I'm using a database on a server that is shared by 5 workstations. I have some reports that need certain margins and paper tray settings. I will set the page settings in design view and save. Then when I go to another workstation, all the settings have reverted back to what I assume is the default: 1" margins and first paper tray.

It has been suggested to use the print preview view and change the settings there, but that hasn't worked. Access doesn't even offer to save the settings that way anyway.

I even tried splitting the database, but that didn't work either, and caused some strange errors to appear anyway.

Can anyone suggest how to get the print settings to stick? I would be extremely grateful.

 

[ChristopherM]

Are you using different printers on the different workstations? I have had this problem where, on printing the report, Access resizes the margins apparently based on information it receives from the printer driver. If this is the case, I think you would have to split the database, whatever the results, then set up the report on each workstation

 

[Carol]

Make your changes while in design view and save while in the same view. Also go into the main Tools menu bar and select Options. From there select the General Tab. Make sure that you uncheck the Perform Name Auto Correct option.

 

[Chris RR]

If you are using Access 2000, this is a know problem with the "Name Autocorrect" settings. If you have autocorrect set on, Access very kindly "autocorrects" the margins for you. (And if your users have this option set on, the margins will get messed up there...)

You can reset the option in VBA like this:
Public varTrackSetting As Variant
Application.SetOption strTrackAC, False

 

[TLowell]

Thanks for the suggestions. I reset the margins and paper tray on one workstation, then I set the autocorrect feature to off.

The margins now seem to be stable, but the printer still always reverts to its default tray (the autoselect on the HP laserjet 2100). Is there anything else I can do to keep the printer set to the appropriate paper tray? Each report uses its own preprinted form, so it's quite important.

Thanks again, for any help that can be provided.

 

[TLowell]

I just searched the microsoft knowledge base, and they acknowledge this problem as a bug which is fixed in service release 1. Here is the article:
http://support.microsoft.com/support/kb/articles/Q240/8/26.ASP?LN=EN-US&SD=gn&FR=0&qry=autocorrect&rnk=14&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

I'm going to download it now and cross my fingers!