Help! Name not concantinating

[Ruegen]

I have the teacherName & teacherSurname fields and a calculated table field mergednameT that concatenates both names together [teacherName ] & " " & [teacherSurname]



This has worked great for months up until today when someone made a new record. The first name and second entry in ok but the concatenation only picks up the first name!?!

It works for all other records

I thought this might be something with the table so I generated a query with the same concatenation and it too wouldn't work!

I did a compact & repair and it didn't pick up a thing! - any suggestions on what to do or what the problem might be?

[ItsMe]

Maybe the user typed a special character in one of the name fields that caused the VBA to go goofy.

[Ruegen]

Can't see if they have seems like normal text in the field.... any hints?

[Ruegen]

I've tried making a similar record with the same name and that record too has the problem. I made a query with a field that duplicates both name and surname and then merged the duplicates and it works however not it won't directly and sometimes it won't at all...

I've also tried deleting and then retyping in the field.

[Ruegen]

Ok I think I have solved, for some reason there was a name already in the field and as to why that was causing this issue is beyond me (or why it wasn't showing either) - I removed the name and it now works.

Thanks for your help ItsMe - I still have yet to work out why this would cause an issue.

[ItsMe]

Perhaps a carriage return or line feed was there.

[Ruegen]

Perhaps a carriage return or line feed was there.

That could be it - there but not visible.