Annoying label left hanging and unselectable

[JamesWB]

Afternoon, I have an annoying issue.

An old label, previously attached to a combo box, will not delete. I can't select it or move it. I've attached a print screen - it's the one in the lower left of the form called "DeviceTypeDescription".

I've tried things like repairing the DB and also copying the form to another database and copying it back and none of those work.

Any ideas folks?

Thanks for any help.
James

 

[vbaInet]

The label obviously doesn't want to be left out

Does it have properties in the property sheet?

 

[JamesWB]

The label obviously doesn't want to be left out

Does it have properties in the property sheet?

Haha, I think it died but the ghost lingers on.

No, it isn't selectable, so it has no properties, no matter what you try and do in that part of the sheet, all you see is empty cells.

 

[vbaInet]

Ok, I can tell you a few ways but the simplest thing to do is:

1. Create a new form
2. Copy the relevant controls from the old form into the new form
3. Copy the code from the old form to the new form
4. Link the events back up if they haven't been linked back
5. Debug > Compile the code.

 

[JamesWB]

Ok, I can tell you a few ways but the simplest thing to do is:

1. Create a new form
2. Copy the relevant controls from the old form into the new form
3. Copy the code from the old form to the new form
4. Link the events back up if they haven't been linked back
5. Debug > Compile the code.

Hmm, yes, I thought of doing that, but I was a bit hesitant because I wasn't sure about some things. Does it copy over any VBA macro code as well? Also, I tried it, but some of the formatting seemed to go, am I missing something about how you copy elements from one form to another?

 

[vbaInet]

If you're talking about Conditional Formatting, I don't remember if it stays or not. If you're talking about formatting in the Property Sheet then it stays.

Like I mentioned in step 3, copy the code across. Do the steps in the order stated and each one of them.