Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update memo field from memo field - truncating

Status
Not open for further replies.

khs999

Technical User
Aug 3, 2011
11
GB
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top