How do I copy more than 255 characters to a text field in a file geodatabase?

[JeffMcClellan]

Table A: I have a file geodatabase table that with a text field (A-F) with a length set to 2000.

Table B: I have a "Personal Geodatabase Table" (very old version of Geographix) that I have joined to table A.

Table B contains a text field (B-F) with length 2,147,483,647, however the data is never more that 1,500 characters.

I need to copy data from B-F to A-F.  I am using Field Calculate to attempt this, however the data is being truncated at 250 characters.

Further testing: Using Field Calculate and simply putting a string of more than 250 characters will get truncated if two table are joined.  If I remove the join, the string gets load in the field properly.

Is seems when the tables are joined, there is a 250 character limit on text fields.  What have I done wrong to cause this.

ArcMap 10.5.1.7333

Thanks

Jeff

[JeffMcClellan · Accepted solution]

After installing 10.6 the problem went away.  I don't know if 10.6 fixed the problem or re-starting my workstation fixed it, but it is now working as expected.