Runtime form changes saved

  • Thread starter Thread starter Mike Morton
  • Start date Start date
M

Mike Morton

Hello

I have a form which is designed to make it easy to read during development,
but redesigned at runtime based on the data to display.

I wish to allow this without the design changes being saved when the form is
closed at runtime. I imagine that this is easily achieved, but can't find
the correct property.

Any help in this would be greatly appreciated as it's driving me nuts,
mainly because I know it's going to be blindingly obvious once I find out.

Thanks

Michael Morton
 
Runtime changes are not saved unless the form or report is opened in design
view, changed, then saved. I suggest that you place all the controls on the
form during development, then show or hide them based on your data display
requirements.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
1) Set the AllowDesignChanges property of the form to "Design View Only"
(aka False) rather than the what-were-they-thinking default of "All Views"
(aka True).

2) With the above in place this is redundant, but when closing the form via
code you can include a "don't save changes" instruction:
DoCmd.Close acForm, Me.Name, acSaveNo
The "Save: Yes/No/Prompt" argument is applied to changes made to the design
of the object (i.e., the Form itself), *not* to any data on the form.


HTH,
 
Back
Top