If the last character of a string is "P" ...

**mike2** · May 25th, 2004, 06:35 AM

Hi...
Im pretty sure that this is simple...
But i cant get it !

Anyway i want to check if the last character of a textbox is "P"
Can anyone help with that?

Thanks!

**rameshk** · May 25th, 2004, 06:41 AM

try
if UCASE(right(TRIM(text1.text),1)) = "P" Then ....

**mike2** · May 25th, 2004, 06:43 AM

Nope...
Doesnt work...

**baja_yu** · May 25th, 2004, 06:43 AM

VB Code:

If LCase(Right(Text1.Text, 1)) = "p" then
   MsgBox "Last chr is P"
End If

**mike2** · May 25th, 2004, 06:46 AM

Didnt work either...

**baja_yu** · May 25th, 2004, 06:52 AM

Then you are doing something wrong.
Can you post your project?

Here is my example of the project and it works fine.

**manavo11** · May 25th, 2004, 12:29 PM

Originally posted by mike2
Didnt work either...

What is the problem?

**vbasicgirl** · May 25th, 2004, 03:50 PM

maybe you have a carraige return at the end of your text because trim wont trim with that there, try this.

VB Code:

If Right$(Trim(Replace(Text1.Text, vbCrLf, "")), 1) = "p" Then
  MsgBox "p is the last char"
End If

casey.

Thread: If the last character of a string is "P" ...