How do you recognize an event property through code?

[Pau Ventura]

Hello,

I'm looping every form and each control in it.
Then I'm looping the properties collection of the control.

Through code, I would like to know if a property of a control in a form is
an event one, or format or data or others (I need event properties only).

MS Access separates them. For example: the tags in the properties window or
the documentation reports tool.

I think name prefix is not a valid method, because there are On, After,
Before... And OCX or ActiveX controls can have their own properties with
their specific names...

Thank you

 

[Marshall Barton]

I'm looping every form and each control in it.
Then I'm looping the properties collection of the control.

Through code, I would like to know if a property of a control in a form is
an event one, or format or data or others (I need event properties only).

MS Access separates them. For example: the tags in the properties window or
the documentation reports tool.

I think name prefix is not a valid method, because there are On, After,
Before... And OCX or ActiveX controls can have their own properties with
their specific names...

I think(??) that Access has a list of the properties for
each tab in the Properties sheet. I leap to that conclusion
based on the clue that some properties are missing for some
types of controls.

With that in mind, I suggest that you create a table with
your list of properties that you want to check.

Alternatively, It might(?) be possible to check all
properties except a few specific ones like ControlSource,
DefaultValue,etc) for legal values, but this seems even less
desireable than maintaining your own list.

 

[Pau Ventura]

I think(??) that Access has a list of the properties for
each tab in the Properties sheet. I leap to that conclusion
based on the clue that some properties are missing for some
types of controls.

With that in mind, I suggest that you create a table with
your list of properties that you want to check.

Alternatively, It might(?) be possible to check all
properties except a few specific ones like ControlSource,
DefaultValue,etc) for legal values, but this seems even less
desireable than maintaining your own list.

Thank you Marsh. For standard controls could be the best solution.