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"

Expand|Select|Wrap|Line Numbers

  
If IsNull([ComboBox]) And ([ComboBox]) Then

[ComboBox] = Null

End If

Thanks

ChipR

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

Expand|Select|Wrap|Line Numbers

 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 :

Expand|Select|Wrap|Line Numbers

 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

Quote:

Originally Posted by NeoPa

It's possible to use :

Expand|Select|Wrap|Line Numbers

 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)!

Formula help

re: Formula help

re: Formula help

re: Formula help

re: Formula help

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about