Last character of a string

[1jet]

Hi all,

Please read my code...

Function test()

Dim frm As Form
Dim project_box As Control
Dim project_name As String

Set frm = Forms!frmEmployeeTimesheet
Set project_box = frm.cboSelectProject1

project_name = project_box.Name

MsgBox "You have just updated " & project_name

End Function

As you can see I've managed to get the NAME of a combo box into a STRING value and have it output on a message box.

How would I get just the LAST character of that string?

Cheers all

 

[chergh]

Have a look at the 'right' function

 

[1jet]

piece of cake
thank u