Right/Left function

Dear all,
everytime i use the Right or Left function i get the error "Datafield expected". I can remember that with SP2 for VB5 the function worked fine but now it doesn't why? To walk around that problem i'm always using the Mid function but i don't think that's a good solution.

Do you still get the error if you use VBA.Left() and VBA.Right() ?

do you know how to use the left function?

Code:

---

Dim myString As String

myString = Left("Hello my name is David!", 5)
'myString now = "Hello"

'or for the right function

myString = Right(""Hello my name is David!", 6)
'myString now = "David!"

---

understood :)

if not email me ok

Check out how old this thread is! Look at the post date on the first post in this thread!.. :p