When codes are deleted are they really gone ?

[Guest]

I am redesigning my form to replace a bloated form.
I have several unbound labels and text boxes that were created in the design
process that I no longer need.
In other words, I ran into trouble changing labels into text boxes and had
to keep deleting them from the tab form.
Help appreciated. I don't want to end up with another bloated form.

 

[Wayne Morgan]

They are supposed to be gone after you compact that database file. However,
there is a bug in the 2002/2003 file format that does keep references to
some deleted items around (not code though), even after a compact. To fully
get rid of everything, you would need to import all of the object from the
file into a new, empty mdb file. Once you do that, open the code editor
(Alt+F11) and go to the Debug menu and compile the transferred code.

There is a decompile option that frequently helps by getting rid of the
compiled code without transferring everything into a new database. This can
be done by using the /decompile switch as you open the database or by
changing the References in the code window (Tools|References). Just check
something you don't need, click Ok to close the References dialog then go
back in an uncheck the item you just check. Again, click Ok to close the
dialog. This should also decompile the code.