Change the order of the letters in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a build in function in Access that replace the order of the letters
in a string?
for example: I have a field in a table that has a value "refO"

I would like a function that returns "Ofer"

I have a function that I created, but I'm just wondering if there is a build
in function.
Thanks for your help
Ofer
 
StrReverse()

as in...

Private Sub cmdReverseString_Click()

Dim startingstring

startingstring = InputBox("Enter your string")

MsgBox ("Starting String = " & startingstring & Chr(13) & _
"Reverse String = " & StrReverse(startingstring))

End Sub
 
Thank you,
I had a feeling that such a function exist, but I couldn't remember the name
of it.

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top