Results 1 to 2 of 2
Thread: Memo Field - Access to Excel
2012-05-16, 10:45 #1
- Join Date
- Aug 2001
- Frederick, Maryland, USA
- Thanked 2 Times in 2 Posts
Memo Field - Access to Excel
Using Access 2007 and Excel 2007.
In a nutshell. Users fill out a cell in excel that contains comments. Total length of comments may exceed 255 characters. The comments are imported into access and stored in a table as a memo field.
Then, when creating excel reports from access, the comment field is exported back to excel. Fields that exceed 255 characters are truncated to 255.
To get around this, the data in access is parsed into 250 character long sections and then written to adjacent cells in excel such that if the comment was 1000 characters, 4 cells in excel would hold each 250 segment. A formula is then written in excel to contactenate these four cells into one cell.
HERE IS THE ISSUE
All of the code is done in access. When excel opens, the concatenate formula is correct but it still only shows the 255 characters. If I double click on the cell manualy in excel and press enter the excel cell populates with all of the characters. What can be done so when excel opens all 1000 characters show in the one cell. I tried to force a double click in each cell in code, copy and paste special values in code, re-calc, etc., but can't get it to work. Help.Regards,
(It's been a while!)
2012-05-16, 12:24 #2
- Join Date
- Mar 2002
- Newcazzle, UK
- Thanked 466 Times in 444 Posts
Can you post an example where only 250 chars are shown.
When I try to create an example, I see 1000 chars.
..I see the 1000 chars.