The MID function returns a specified number of characters from the chosen starting position.
MID( [ Text], [ Start Number], [ Number of Characters] )
Text is the string of text or a reference to some text .
Start Number is the position of the first character you want to retrieve.
Number of Characters is the amount of characters you want to retrieve from the specified starting position.
To start retrieving characters from the beginning of the text, the Start Number must be set to 1.
|MID(ProductCodeTextBoxReturn, 1, 3)||The MID function will retrieve 3 characters from the return value of the ProductCodeTextBox, starting at the first character in the text.|
Number of Characters
Result of the MID function