Controls on Forms..........Advice Please

D

Dermot

When A control say...command button is placed on a form and named say
cmdTest....
If I then delete the control and place another and name it cmdTest.......a
message appears sayin the control already exists.....although it has been
deleted.

Question1
I assume the Name of the control must be stored and this is the reason for
the message...where is the data relevant for the control stored?

Question 2
How can the control data be deleted also if a command button is dleted.

Thanks
Dermot
 
A

Allen Browne

To avoid the problem:

1. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database after deleting the control:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair
 
Top