Truncate text

[jgelpi]

I have the following code adding the string word "OUT" at the end of a user's name. I need a way to remove the "OUT" if necessary.

 
If varOutCheck = vbYes Then
        Combo42.Value = Combo42.Value + " OUT"
        Exit Sub
    Else
        BegDayIn.SetFocus
        Combo42.Visible = True
        cboName.Visible = False
        Command48.Visible = True
        Exit Sub
End If

I am looking for something to do the following (I know this isn't the correct code, just hope to help you get the idea):

 
If cboName.Value ends in " OUT" Then
        cboName.Value = cboName.Value - " OUT"
End If

Thanks for your help!

[RuralGuy]

How about something like:
If Right(Me.cboName,4) = " OUT" Then
Me.cboName = Left(Me.cboName, Len(Me.cboName)-4)
End If

[jgelpi]

That did it! Thanks a lot RuralGuy!

[RuralGuy]

You're very welcome.