Recent content by DHudson

what about if I'm not using forms, but manually updating fields

Access 2010: I have 6 fields, each with <255 characters. I'm trying to concatenate them all into one summary field. When I try and set up a calculated field - it does not allow me to set up as a memo field - only a text field - so it truncates anything >255 in the summary. My end...

2010 for both Excel and Access -- that could be the problem - Microsoft "upgrade"

from researching blogs looks like I'm going to have the same issue when exporting... I'm just splitting into 6 separate fields - then I'll concatenate after exporting. So much for Access making my life easier.

Thanks - Did each step - still truncating. I had already tried setting up the first 5 rows with >255 character fields before inputting. States it is a memo field, but after import, still have truncated data. I even did a manual import where you can set the field, before import, to a memo...

Just tried - what do you mean by "delete the data" ? go to each cell and erase the data? I tried what you stated but didn't delete the data - didn't work - field getting truncated didn't come over at all :banghead:

I'm doing a manual import into Access (2010) from Excel, changing the field to a "memo" field, which is supposed to be practically unlimited. However, when I import - field truncates at 255 characters. I need for it to import all the characters but have run out of ideas.