Right/Left function

[wzipp]

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.

[Mark Sreeves]

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

[da_silvy]

do you know how to use the left function?

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

[tomcatexodus]

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