[AccessD] Dirty Cancel Clear all controls

[Arthur Fuller]

This bug has been lurking in Access VBA for years, and other than the fact
that I know what to do when it bites me, I have no information or insight
regarding its cause or this bug, or the apparent inability/unwillingness of
the Access team to repair it.

What I have discovered, through trial and error rather than insight, is
that a second solution exists: export the code to a text file and then
re-import it, which is functionally the same, of course. I've done this and
noted that the "junk code" is magically eliminated during the export.

Sidebar question:

I've never inspected the exported text from a form to see if the
re-imported text can totally recreate the form of interest. Do you know? My
thought is that somewhere all this data is stored as text, but perhaps
limits its export. I don't really know, but if it is, then
reverse-engineering some samples ought to provide enough information to
design a text-template system that auto-generates a bunch of forms (perhaps
containing subforms, in which case recurse).

I've written a lot of code similar to the spec described above, in
languages other than Access, but never tried it in Access. Do you have any
experience in this sort of experiment?

Arthur
​