I've been working in forms today and ran across something I wondered about in reports, and maybe have happened there to contaminate my report design.
So, I have forms and reports with colored headers. They can change with code on open.
Also, the captions change based on the language being used.
I also have a Print button that changes the colors to black and white.
So, I tried printing the form, and got an error (I'll deal with that later).
If I answer yes to this question (below in the image), my form design gets changed from the original when it started. Not good.
How should I make run-time changes to a report or form, changing the form/report properties, but not have those changes be permanent if there is an error (especially encountered by a user and they press yes!)
If the form/report closes normally, then the changes aren't saved to the design, nor is there a dialog box like shown below.
I maybe doing something wrong when changing form properties? Like I need to do a local instance or whatever Access does in this situation?