if statement with multiple conditions gives Type mismatch error

[bbrazeau]

The following gives a "Type mismatch" error. txtShrink's format is set to general number. The highlighted line is the ElseIf line. Did I write the if condition wrong?

If IsNull(Me.txtShrink) Then
MsgBox ("Enter a shrink rate for the new Material")
ElseIf (Me.Category = "Metal" Or "Other" And Me.txtShrink <> 0) Then
MsgBox ("Non plastic parts use zero shrink")


Me.txtShrink = 0
Exit Sub
End If

[pbaldy]

The syntax is off; try:

ElseIf ((Me.Category = "Metal" Or Me.Category = "Other") And Me.txtShrink <> 0) Then

The type mismatch would imply a numeric/text issue, so double check the data types of both fields.

[jzwp11]

I think you need something like this:

ElseIf (Me.Category = "Metal" Or me.category= "Other" And Me.txtShrink <> 0) Then

oops, I see Paul beat me to the punch

[RayMilhon]

Try this
If Not isnumeric(txtshrink) Then
msgbox("Enter a Shrink Rate for the New Material")
ElseIF (me.category = "Metal" Or "Other" and me.txtshrink <> 0 Then
msgbox("Non ....")
me.txtshrink = 0
End if
Exit Sub

[RayMilhon]

both Paul and jzw beat me and I missed the Or "OTHER" Portion.

[pbaldy]

Fastest fingers in the west...or the midwest!

[RayMilhon]

I'm as far west as you can get (California) but my family moved here from Kansas.

[pbaldy]

If you're in Southern California, there's a pretty good chance that I'm farther west than you are (I'm in Northern Nevada)!

Do we call you Toto since...wait for it...you're not in Kansas anymore?

[bbrazeau]

Wow! Thank you for the replies, all of you. I only got to the 1 st one, because it worked like a dream. That darn syntax messes me up every time. Thanks again.

[pbaldy]

Happy to help. Note the parentheses I added, which were a guess at your desired logic. When you mix "And" & "Or", you should add parentheses to clarify the logic. Otherwise you might get unexpected results.

[RayMilhon]

I'm about 120 Miles West of Las Vegas off Interstate 15

[pbaldy]

I'm about 120 Miles West of Las Vegas off Interstate 15

You're so far east of me I can practically call you an Easterner.

[RayMilhon]

Just took a look at a map and guess I need to learn a bostonian accent now.

[pbaldy]

LOL! It's one of those trivia questions you can win money with, as everybody assumes that anyplace in CA is west of anyplace in NV, when in fact Reno and Carson City NV are west of Los Angeles.

[RayMilhon]

I'll have to remember that.