Results 1 to 6 of 6
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Convert Memo Field to Text Field in a Make Table Query

    I am running a make table query, and in the "source" table, the two fields are autoNumber and memo, in my destination table, I need the memo field to be converted to a text field. Is this possible?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Data will never exceed 255 characters? Can you just change the data type of the field in source table?

    Try concatenating an empty string to the memo field, worked when I tested it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    Quote Originally Posted by June7 View Post
    Data will never exceed 255 characters? Can you just change the data type of the field in source table?
    Never will exceed! And unfortunately I can't modify the source table.

    Quote Originally Posted by June7 View Post
    Try concatenating an empty string to the memo field, worked when I tested it.
    How would I do this? I am not following?

  4. #4
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    Quote Originally Posted by jo15765 View Post
    Never will exceed! And unfortunately I can't modify the source table.


    How would I do this? I am not following?
    there's always the coding method! and if I'm not mistaken....I believe Allen Browne has an article about this issue somewhere doesn't he?

    why convert anyway? what gives?

  5. #5
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    I will have to search for Allen Browne's article. I need to convert so that I can link on two fields in a query. I can't join memo to text, and since changing it in the source table is out of the question, I was just going to do a make table query and change the memo to text.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Expression to concatenate empty string:

    [fieldname] & ""

    Here is Allen's article http://allenbrowne.com/ser-63.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. rich text memo field
    By jedder in forum Reports
    Replies: 1
    Last Post: 05-11-2012, 02:48 PM
  2. Replies: 0
    Last Post: 10-03-2011, 03:32 AM
  3. Replies: 5
    Last Post: 08-29-2011, 05:17 PM
  4. Highlight text in memo field
    By silverspr in forum Programming
    Replies: 2
    Last Post: 03-27-2011, 04:58 PM
  5. Need help with Memo field text format
    By sprovoyeur in forum Access
    Replies: 1
    Last Post: 05-14-2010, 08:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums