Full Version: String concatenation problem
UtterAccess Forums > MicrosoftŪ Access > Access Forms
madctch
I am trying to combine the values of two fields in a query expression using
CODE
Expr1: [Client Name] & " - " & [Project Name]
but on some values it fails and only provides me with the [Client Name] value. Any solution ideas?
niesz
Is there indeed a Project Name for the associated Client Name when this occurs?
madctch
Yes. But on these select records in the query it does not display them. In fact it doesn't even display the " - " it just stops at the [Client Name]
niesz
Any way that you can post a sample of this behavior?
oes your Client Name field contain a CrLf (CarriageReturn - LineFeed) character at the end? causing the "- ProjectName" to be pushed onto a separate line?
madctch
That was it. Thanks a bunch.
niesz
NP.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.