Field Concatenation (1 Viewer)

[wsaccess]

Hi,

I have a table with First_Name and Last_Name. I have a query to concatenate the 2 fields.
The query is:
Name: [First_Name] & " " & [Last_Name]

When I run the query, the Name field displays only the First_Name.
Strangely, when I double click each row, I can see the concatenated names. But when I move the mouse away, it still displays only the First_Name.

Any ideas, please????

Thanks

 

[Minty]

Name is a reserved word and might be behaving oddly. Try calling it FirstLastName or something else.

 

[wsaccess]

I tried "Full_Name" instead of "Name". But that made no difference

 

[JHB]

Do you have a look up (combo box) set for the field at table level?
Else post your table in a new database, (zip it).

 

[arnelgp]

do you have format characters in your field or field in your query?

 

[wsaccess]

No Combo Box/Lookup/Format Characters
I tried to copy the table to a new database, and it is the same results!
It is really strange, because I have done concatenation before without any problems...

 

[bob fitz]

Can you post a copy of the db

 

[wsaccess]

Here it is... in zipped file

 

[Minty]

Okay that is weird....

 

[JHB]

You've an invisible character (ASCII code = 0) at the end of the names. Add a space or something else in the end and then it works.
You can run an update query where you take the length of the name minus 1, left function.

 

[bob fitz]

Okay that is weird....

Yes it does seem strange.
I suspect that the problem is with the the data in the table of names because if you examine the length of the a field with Len() it returns a value that is one more than it should be. Also, if you over type a name in the table it works as one would expect it to.

EDIT:
Sorry, didn't see the post by JHB

 

[wsaccess]

You've an invisible character (ASCII code = 0) at the end of the names. Add a space or something else in the end and then it works.
You can run an update query where you take the length of the name minus 1, left function.

Yes, that was exactly the problem and solution...
Thank you very much.....

 

[JHB]

Thank you very much.....

You're welcome - good luck.