Does anyone know where Microsoft Access stores the page setup settings when you customize a report? I have a report that uses a custom form size and I would like to know EXACTLY where Access saves those settings, what is saved, and how it is saved. I a very specific problem and I have been trying to figure it out for a long time and this information would be very helpful. I am using Access 2003 will all of latest updates, and this is not the auto-naming problem.
I have 1 application that is used on multiple networks (it resides on the clients) each of the reports have been formatted to use the default printer and use the custom form for page width and height settings. In the registry of the print servers where the custom form is listed, I see the same entries, but the hexidecimal data values are different in some cases. In the cases where the data values are the same I can move the Access application between the clients on different networks and the reports print fine, but as soon as I move the Access file to clients that use a different print server, where the hexidecimal value for the custom form is different, the reports stop printing correctly. When I go into the design view of the report and view the page setup settings, the custom form I created and used is not selected. I have 24 print servers 7 of them have matching hexidecimal data values for the custom form and the Access application will print correctly from any client that uses any one of those print servers. If I move the Access application to a client that uses a print server where the hexidecimal data value does match, the reports will not print. In all 24 networks, it is the absolute same, if the hexidecimal values match everything prints fine, if they don't it won't print - it is very consistent!!! There is not one case in which the registry values are different and it still prints fine.
This leads me to believe that Access is using the registry values for the custom forms in order to determine which form to use, not the actual name of the custom form.
So again, my question is exactly where does Access save the page setup settings, how does it save them, what does it save and how does it call those settings?