Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using part of a string value 1

Status
Not open for further replies.
Spon349

Spon349

Technical User
Joined
Apr 24, 2001
Messages
3
Location
GB
Is there any way to grab part of a string that's the current value of a form control? The
Code: 
Characters
property provides the exact functionality I need, but it doesn't seem to apply to form values.

Thanks
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question Question
put value in input box web page
Replies
0
Views
401
2009luca
2009luca
IcarusHallsorts
  • Locked
  • Question Question
I have a column of data in Column A
Replies
3
Views
730
Andrzejek
Andrzejek
remeng
  • Locked
  • Question Question
Using Err.Raise question
Replies
2
Views
2K
mintjulep
M
remeng
  • Locked
  • Helpful tip Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
2K
dhookom
dhookom
Submeg
  • Locked
  • Question Question
Selecting shapes based on its name and then arranging them in a circle
Replies
2
Views
458
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top