String Question

[Blackbelt12]

How would I do something like this?

If Left(Me.lstUsers.Text, 1) != "@", "+" Then

Like how would I make it say "If the first letter on the selected user doesn't equal @ or + Then..."

[RhinoBull]

You are practically there...

If Left(Me.lstUsers.Text, 1) <> "@" Or Left(Me.lstUsers.Text, 1) <> "+" Then

Else

End If

You can also use Select Case:

Select Case Left(Me.lstUsers.Text, 1)
    Case "@", "+"
        'do something
    Case Else
        'do something else
End Select

[brucevde]

If Left(Me.lstUsers.Text, 1) <> "@" Or Left(Me.lstUsers.Text, 1) <> "+" Then

The above statement will always evaluate to True.

Use AND instead of OR when checking for inequality.

If Left(Me.lstUsers.Text, 1) <> "@" AND Left(Me.lstUsers.Text, 1) <> "+" Then

Another way to achieve the same results.

If Not(Left(Me.lstUsers.Text, 1) = "@" Or Left(Me.lstUsers.Text, 1) = "+") Then

[RhinoBull]

In the context I posted it was meant to be "=" instead of "<>", however you are right - "as is" it will always evaluate to True.