Question Access 2007 Error MSG Tried every thing .. still no solution !

[MartinThe11th]

all what i am trying to do , is displaying a msg box when a label is clicked !

Private Sub Label123_Click() 
MsgBox "TEst" 
End Sub

any Idea what's going on !?

access 2007 / windows 7

 

[Galaxiom]

Is there an event by the same name in a subform?

 

[MartinThe11th]

Is there an event by the same name in a subform?

no there isn't

 

[gemma-the-husky]

this should work - try compiling the dbs see if there are some errors

 

[MartinThe11th]

this should work - try compiling the dbs see if there are some errors

did that too , same issue

 

[boblarson]

Perhaps you have some corruption going on. Try importing all of your objects into a brand new ACCDB file. (don't copy and paste, or drag and drop - IMPORT)

 

[MartinThe11th]

Perhaps you have some corruption going on. Try importing all of your objects into a brand new ACCDB file. (don't copy and paste, or drag and drop - IMPORT)

did that too , same problem

 

[boblarson]

Maybe post your database here (remember to compact and repair first and then ZIP the file).

 

[shadow9449]

How does a label have a click event...??

SHADOW

 

[boblarson]

How does a label have a click event...??

SHADOW

It does in Access 2007 on reports.

 

[shadow9449]

That's interesting. What about forms? Is this a form or report?

SHADOW

 

[boblarson]

That's interesting. What about forms? Is this a form or report?

SHADOW

Labels have always had a click event on forms, but Reports have not UNTIL Access 2007.

 

[shadow9449]

Labels have always had a click event on forms, but Reports have not UNTIL Access 2007.

Indeed. I was mistaken. I was thinking of the labels that get created as a caption for a text box which do not have an event.

SHADOW

 

[boblarson]

Indeed. I was mistaken. I was thinking of the labels that get created as a caption for a text box which do not have an event.

SHADOW

Actually, those do have events too. But you have to access them from the VBA window and not through the form's properties window.