Solved If a combo box field is empty Then expression (1 Viewer)

[angekap]

Hi I have a form and at the end I have where if the message box answer is YES and the combo box (SELSUPPLIER) value is not filled Then I want it to follow the code. I'm stuck at the bottom line:

Response = MsgBox(Msg, Style, Title)

If Response = vbYes And "SELSUPPLER" Is Null Then

I think I am not using the IsNull command correctly ?

Can anyone help ??

Thanks

 

[pbaldy]

Try

If Response = vbYes And Len(Me.SELSUPPLER & vbNullString) = 0 Then

You could use IsNull() but the above also tests for a zero length string.

 

[angekap]

Try

If Response = vbYes And Len(Me.SELSUPPLER & vbNullString) = 0 Then

You could use IsNull() but the above also tests for a zero length string.

 

[angekap]

Hi Yes it works however my mistake I should have written if it is not 0 !! How would I write it ..Thanks Again !!!

 

[pbaldy]

The value is not 0, or it isn't Null? One of these

If Response = vbYes And Me.SELSUPPLER <> 0 Then

If Response = vbYes And Len(Me.SELSUPPLER & vbNullString) > 0 Then

 

[angekap]

The value is not 0, or it isn't Null? One of these

If Response = vbYes And Me.SELSUPPLER <> 0 Then

If Response = vbYes And Len(Me.SELSUPPLER & vbNullString) > 0 Then

Thank You So Much worked like a dream !!! Much Appreciated !!

 

[pbaldy]

Happy to help!