-
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
-
hehe...
Check out how old this thread is! Look at the post date on the first post in this thread!.. :p