Error using function in control source expression

NachoMan

Registered User.
Local time
Today, 14:23
Joined
Sep 28, 2003
Messages
56
Can anyone tell me why I keep getting errors when I try to use a standard string function in my control source expression for my report field?
This is the expression:

Code:
="POC: " & [TitleRank] & " " & [FirstName] & " " & [LastName] & " at  x-" & Right([WorkPhone],4)


I keep getting the following error message for some reason:

"The expression you entered contains invalid syntax, or you need to enclose you text data in quotes.

My text data is in quotes already, so I'm not sure what I'm doing wrong here. I also tried putting the function part in brackets, but that did not solve the problem. Any ideas?
 
Are you sure everything is spelled correctly? I just used your example with a sample on my end and this works ok...

="POC: " & [test1] & " " & [test2] & " " & [test3] & " at x-" & Right([test4],4)
 
Not sure what the problem is. Everything is spelled correctly. I don't have the problem until I try to add the Right() function in there. There is no special way that I have to wrap functions in expressions are there? Could this be a reference problem? I don't see anything missing.
 

Users who are viewing this thread

Back
Top Bottom