Memo field character truncate issue

[mac.vba]

Hi,

I need an assistance here in MSAccess. I have a fields in a table with type as Memo that should hold more than 255 characters. I'm trying to update the fields for 1001 characters through VBA.

What's happening:

1. The records is getting saved but only 255 characters are displayed in the table field
2. If the same records called in a text box through VBA, all the 1001 characters are seen there
3. Only 255 characters are seen when the record is copied in an excel sheet to validate
4. Even when manual text entered in the field, doesn't show all the characters, though accepts all




What so far I have done:
1. Checked the format of the field
2. Unicode compression; tried with Yes and No as well
3. Text format; tried with Plain and Rich text
4. Checked the variable declaration in the VBA section; it’s string


:banghead:

I have been directed to "http://allenbrowne.com/ser-63.html" site by multiple people in multiple forums; but was of no use.

Do we have a meaningful way around?

 

[arnelgp]

then how do you do it in vba, can you show the code.

 

[Trevor G]

Check out this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=257440

 

[arnelgp]

so, is that you thanking all the way, mr.mac.vba.

possibly the easiest solution, on my opinion, is to include your memo field first, in all your query before any other fields.

if you have a Select query to import, ie:

select field1, field2, field3, fieldMemo Into NewTable From OldTable

then you must put the memofield first:

select fieldMemo, field1, field2, field3 Into NewTable From OldTable

that was from mr.allenbrown suggestions. i havent tested it extensively, but on a couple of 4 or 5 test i made, so far all the memo i copied to new table, have all their memo intact (not truncated).