Append Query clips Memo Field 2

[perrymans]

The source is a Memo field, the destination is a Memo field, but the Append query truncates the field information.

How do I get around this?

Thanks. Sean.

 

[Remou]

This should tell you why:

http://allenbrowne.com/ser-63.html

As a work-around, a recordset may suit.

http://lessthandot.com

 

[TheAceMan1]

How are ya perrymans . . .

Here's the basic idea:

[blue]   Dim db As DAO.Database, rst As DAO.Recordset
   
   Set db = CurrentDb
   Set rst = db.OpenRecordset("[purple][B][I]TableName[/I][/B][/purple]", dbOpenDynaset)
   
   With rst
      .AddNew
      ![purple][B][I]MemoFieldName[/I][/B][/purple] = Me![purple][B][I]MemoFieldName[/I][/B][/purple]
      .Update
   End With
      
   Set rst = Nothing
   Set db = Nothing[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]