Re: DAO Question


"J. Novotny" <team@xxxxxxxxxxxxx> wrote in message
news:1140851582.485105.147810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Jennifer, thank you for your reply!

dbMemo (not dbMenu) is actually the data type and it's Access database.
It should handle unlimited number of characters if I am right, but it
does not for me.

For liFt = 1 To Len(frmMain.rtfNotes.TextRTF) Step 64000
odToDoLists!Notes.AppendChunk Mid$(frmMain.rtfNotes.TextRTF,
liFt, 64000)
Next liFt

You should be able to assign Megs of data to a Memo field if you want to.

I would try two things. First, try dropping the loop and assigning the whole
thing at once:
odToDoLists!Notes = frmMain.rtfNotes.TextRTF

Second, if you want to use the ApppendChunk loop, try adding
odToDoLists!Notes = ""
before the For loop, to clear the field before appending.

Are you sure the error is caused by the Memo field? "Crashes" is not very
informative; what error is raised, or what exactly happens?



.

Relevant Pages

  • Re: field is wiped out without warning
    ... I think I might have to include two fields in place of the one memo field. ... you can use DAO to loop through all the ... if your memo field is in an update query ... Sub HuntForMemofldInQueries() ...
    (comp.databases.ms-access)
  • Re: Major Performance Bug in DataTable?
    ... I can still change the data type during a call to ... and EndLoadData from the first loop the second loop will be at least ... is internally generating and swallowing an exception. ... Running the posted code in the debugger is even worse. ...
    (microsoft.public.dotnet.general)
  • Re: Looping variables - Integer vs Long
    ... >> Because it's not the narrowest possible data type for the ... >> purposes of the loop at hand? ... significant in any loop that could be handled by an integer. ...
    (comp.databases.ms-access)
  • Re: field is wiped out without warning
    ... till you find the control whose source is your memo field and then check ... you can use DAO to loop through all the ... if your memo field is in an update query ... Sub HuntForMemofldInQueries() ...
    (comp.databases.ms-access)
  • Re: ms access quirey question
    ... Use a Text data type to store data such as names, addresses, and any ... A Text field can store up to 255 characters, ... Use the Memo data type if you need to store more than 255 characters. ... A Memo field can store up to 64,000 characters. ...
    (comp.lang.java.programmer)