Formula help

[NigelBrown]

Hi All,

This is prob easy but I have the below formula that is not working, how do I include an And statement within the IsNull to look at 2 combo boxes ? I have tried to do it a couple of ways but get the same error "Type Mismatch"

[code=vb]

If IsNull([ComboBox]) And ([ComboBox]) Then
[ComboBox] = Null
End If

[/code]


Thanks

[ChipR]

IsNull only takes one parameter, so you'd have to do it twice.

If IsNull(control) And IsNull(otherControl) Then
  ...
End If

[NigelBrown]

Thanks ChipR - the only thing I did not try !!!!!
Thanks again

[NeoPa]

It's possible to use :

If IsNull(Control+OtherControl) Then
...
End If

but it is a little esoteric and relies on Null propagation.

I'd actually recommend Chip's answer in most cases.

[ADezii]

It's possible to use :

If IsNull(Control+OtherControl) Then
...
End If

but it is a little esoteric and relies on Null propagation.

I'd actually recommend Chip's answer in most cases.

Getting esoteric on us, hey NeoPa! (LOL)!