Access Form - Label Problem...Am I Losing My Mind?

[hoialmen]

Hi All!

I am working on a user form in Access and seem to be experienceing some odd behavior. I have one form where NONE of my labels have event properties(?). I have checked all the other forms in the application and they seem to be functioning properly. Has anyone ever seen this behavior and, if so, how do I fix it? I would like to add an "On Click" event to some labels on this form but don't have that option. Weird.

Any assistance will be greatly appreciated.

Thanks in advance,


Nathan C. Hoialmen
President
Encephalon Business Solutions, LLC

http://www.encephalon.net

 

[RoyVidar]

Hi!

Not 100% sure on this, but I think when you have labels assosiated with controls (as in wizard created forms/dragging the control from the field list to the form) you don't have label events.

When creating a label "manually" from the toolbox, you have some events.

Roy-Vidar

 

[hoialmen]

Interesting...

Just out of curiosity, I tried copying one of these dysfunctional labels and pasting a copy of it onto the form. Guess what? The copy has event properties. So, for now, I am just going to copy, paste and replace the labels that are giving me trouble.

I would still like to know if anyone else has experienced this behavior and if you discovered a solution to the problem.

Thanks again!



Nathan C. Hoialmen
President
Encephalon Business Solutions, LLC

http://www.encephalon.net

 

[MakeItSo]

Confirmed, Roy.
Just tested with a few... ;-)

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[hoialmen]

Thanks Roy!

Yeah, I think you're right. I discovered that making a copy of the label resolved the problem (previous post). The form I am working on was created by someone else and it's possible that they dragged the fields and labels from the field list (as you explained). I usually make all my labels manually and therefore have never experienced this problem.

Thanks again for the prompt response.

Regards,

Nathan C. Hoialmen
President
Encephalon Business Solutions, LLC

http://www.encephalon.net

 

[rdodge]

That is correct, if a label is attached to a control, it does not have any events associated with it. However, clicking on the attached label has the same effect as clicking on the control that it's attached to. That's how I have my switch board screens setup with Option Buttons within a Option Group Frame, so as when I click on an attached label or the option button itself, the Click Event of the option button is triggered.

This information is also confirmed in the help file dealing with the Click Event, which can be found on the Content's tab of the Help Window drilling down the following topics:

Microsoft Access Help
Programming in Visual Basic
Events
C
Click Event

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.