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:
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?
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?