check if control has property

[jonnie_c]

I am trying to cycle through all fields in a form and check to see if the value has been modified. I am doing this by checking to see if control.OldValue = control.NewValue. I seem to be running into problems, however, when the property does not seem to exist. Is there any way that I could check to see if there is a OldValue property for the control so that if not I can ignore that control?

 

[seven11]

Most likely what you will have to do is check to see what the control type is first before you try to access the property. If the control is something that can have a old value, then perform the comparison, else move to the next control.

good luck - 711

 

[llkhoutx]

The Access Cookbook, published by O'Reilly, has a method for doing what you want. It stores the old value in a textbox's tag.