Mid
Using the MID Function
In this tutorial you will learn how to use the MID Function.
The MID function returns a String containing a specified number of characters from a string.
=MID( string, start, length )
string the value you wish to amend
start the character to begin with
length the length of characters you wish to return
In this example we will work with a Name.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
R | i | c | h | a | r | d | | R | o | s | t |
The result is har.
Query
The results using a Query would be
FORM
In a Form you could set the Default Value of a Textbox to
=MID("Richard Rost", 4, 3)
VBA
In a Form add a TEXTBOX control and rename it "txtMid", then you could add the following in the Load Event.
Private Sub Form_Load()
txtMid = Mid("Richard Rost", 4, 3)
End Sub
Courses
Access Expert 14
Access 309
Seminars
Data Encryption
|
SQL 2
|
Web Sync
Tips
See this FREE Tip on Mid and many others.
Blog
See this Blog Post on the Mid function.
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|