Results 1 to 2 of 2
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    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,

    Gary
    (It's been a while!)

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Gary

    Can you post an example where only 250 chars are shown.
    When I try to create an example, I see 1000 chars.
    Using..
    =CONCATENATE(E4,E5,E6,E7)
    or..
    =E4&E5&E6&E7
    ..I see the 1000 chars.

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •