+ Reply to Thread
Results 1 to 2 of 2

Text quantity in Excel form

  1. #1
    Jake
    Guest

    Text quantity in Excel form

    Hi,
    I'm trying to duplicate an Access form in Excel and have run into a problem
    with an Access memo field. I will be uploading the Excel data to Access.
    The user can put a great deal of text in the text box in the Excel form, but
    when he presses the enter button on the form to put the text into the
    spreadsheet I get a runtime error: Application-defined or object-defined
    error. I'm using this code to enter the memo field in the spreadsheet:
    Range("memEventDesc") = memEventDesc. The excel text field refuses to
    receive more than 910 characters with spaces when I click the enter button
    to run the above code. I know Excel is supposed to take 32,000 characters
    in a cell. I've thought of creating another text box on the form, but this
    will complicate uploading to Access later.
    Thanks for any help,
    Jake



  2. #2
    Registered User
    Join Date
    08-24-2005
    Posts
    33
    Change this to:

    Range("memEventDesc").value = memEventDesc

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1