Append Query

[GaryPanic]

Hello Gurus
I have D/ase (2000)
and one of the queries appended a set of wordings from another table (I'm in insurnace so these are endoresments)
my qry works on the append basis I pick an endorsment from a drop down list and push a button and in gos the wording in to a new field (memo format)

all is fine - now the problem if the wording is over 255 chars long I only get 255 chars - now i know this is something to do with text - the fields where the info is coming from is a memo and the field it is going into is a memo - its the append query that decided to format that field to a text size - any ideas on how to get the querie to append memo instead of text size

many many thanks if someone can shed some light on this

 

[adam.greer]

By memo do you mean they are linked tables within access?

If thats the case check the properties of the text field in design view. It would probably say 255 field size (the default).

Try increasing this size, or try reimporting it as a linked table and look for settings which may limit access to 255

 

[GaryPanic]

Tried both these options Data type is "Memo" and I can copy Word text into my memo field >255 chars
so this isn't the problem