Nz() for properties instead of values

[eww]

I understand how the Nz() function is for if you have a blank field and you want to set the value in that field, but I'm looking for a similar function that affects properties. Or can this function work for properties. Basically I want to say, If this control is null, do not have it enabled, if it is not null, leave it enabled. Would I use an IIF() function here? Here's my best guess (though I know it's not right).

Private Sub Form_Current()
Me.txtResubmittalDate.Value = IIf(IsNull(Me.txtResubmittalDate), Enabled = 0, Enabled = -1)


End Sub

[pbaldy]

How about:

Me.txtResubmittalDate.Enabled = Not IsNull(Me.txtResubmittalDate)

[weekend00]

yes, you can use isnull for property
But I don't think the above eww's code would work.

[eww]

Paul that works, thank you.

[pbaldy]

Happy to help.