Query truncates at 255 chars on memo fields

[Menthos]

Hi... I've seen other threads that seem to refer to similar problems, but not exactly my problem.

I've created a select query in Access 2k to list records within a date range. I'm using the query with a mail merge in Word to create a text document, however ever since I added some IIF checks against some of the memo fields (basically to say "Not Supplied" when Null), any memo field over 255 shows question marks for the chars over the 255 mark.

I tried using transfertext in a macro to drop the query results directly to a text file, but it truncates the memo fields totally at 255 chars!!

Hopefully someone knows the solution to this.

Thanks,

Menthos

 

[dodge20]

The workaround is to use parameters for the query.

See if this site helps you any.

http://www.engr.psu.edu/www/trg/isis/docs/Access2002-Merge-Datawarehouse-Notes-New.htm

Dodge20

 

[Menthos]

Hmmm... thanks for the quick response. That doesn't appear to work, or I'm not doing something right... still truncates the memos.

Perhaps I should clarify that the long term goal is to have this query export to a delimited text file that I can tag to a button with a macro. Transfertext will do the trick in theory, but as said above, gets truncated.