Update memo field from memo field - truncating

[khs999]

I'm currently trying to update a memo field from another memo field in my database, but the table I'm trying to update (table1 below) is truncating the memo field at 255 characters, even though the full memo text is shown in the table I'm taking it from (table2 below).

eg
UPDATE table1
Inner join table2 on xxxx = xxxxx
set table1.memo = table2.memo


I've spent ages looking through Google but to no avail. I'm sure it's super easy to fix, but I can't seem to find a solution.

I'm not very clued up on Access, so nothing too complicated please!

Ta

 

[khs999]

After all that I fixed it... so often the way.

I'll post here for others - the format had a @ in it, both in the table and the form.

Cheers