Loses page format (1 Viewer)

[David Thompson]

Every time I move the code between machines (code update etc) the page format reverts back to the default margins of the printer setup. How can I make the forms and reports keep a fixed format ??

 

[Chris RR]

If your using Access 2000, this is a known quirk (putting it kindly). To get around it, go to Tools, Options, General, and turn off the Name AutoCorrect feature.

You'll need to do this on every PC. If you want to do this from code, you need something like this when you open the database:

Public varTrackSetting As Variant
Public varPerformSetting As Variant

Public Const strTrackAC As String = "Track name AutoCorrect info"
Public Const strPerformAC As String = "Perform name AutoCorrect"

Application.SetOption strTrackAC, False
Application.SetOption strPerformAC, False