Using part of a string value 1

[Spon349]

Is there any way to grab part of a string that's the current value of a form control? The

Characters

property provides the exact functionality I need, but it doesn't seem to apply to form values.

Thanks

 

[Aivars]

Hi!

Me.txtText = "Full_Text_for_functions_testing"
Me.txtPartOfText = Mid(Me.txtText, 5, 7) 'Me.txtPartOfText = "_Text_f"
Me.txtPartOfText = Left(Me.txtText, 9) 'Me.txtPartOfText = "Full_Text"
Me.txtPartOfText = Right(Me.txtText, 9) 'Me.txtPartOfText = "s_testing"

See in the Help "Returning Strings from Functions"

Aivars