StrReverse
Using the STRREVERSE Function
In this tutorial you will learn how to use the StrReverse Function.
The StrReverse function returns a string in which the character order of a specified string is reversed.
=StrReverse( expression )
expression a string
In this example we will use the String "ABCDEFG"
The result is GFEDCBA.
Query
The results using a Query would be
SELECT STRREVERSE("ABCDEFG") AS [MyStrReverse];
FORM
In a Form you could set the Default Value of a Textbox to
=STRREVERSE("ABCDEFG")
VBA
In a Form add a TEXTBOX control and rename it "txtSTRREVERSE", then you could add the following in the Load Event.
Private Sub Form_Load()
txtSTRREVERSE = STRREVERSE("ABCDEFG")
End Sub
Courses
Access Expert 25
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|