Referring to objects

[stubbly]

Hi,

I'm trying to write a proceedure in VBA that will change a property of a control that was passed from the calling proceedure.

So


...
ChangeProperty (Cust_Name)
ChangeProperty (Cust_Address)
...


Private Sub ChangeProperty (ChangeField)
...
If IsNull(ChangeField)
ChangeField.SpecialEffect = 0
Else
ChangeField.SpecialEffect = 2
End if
....
End Sub

Problem is it's refering to the value not the actual passed field ref. How can I change it so the properties of the desired field is changed?

Many thanks

[stubbly]

Got the answer. Drop the (). So it's:

...
ChangeProperty Cust_Name
ChangeProperty Cust_Address
...