Text fields shortened in file

[Harry_38]

I got a query with data and a module that converts that data to a .txt file. The .txt file is used to renew, thru an upload, the contents of a website.

I got a.o. 2 fields that describe a course ‘CourseLong’ and ‘CourseShort’. If there is no long description, we use CourseShort. With an IIf statement I select between these two fields:
Description (new variable/field): IIf([Courses.CourseLongL] Is Null; [Courses.CourseShort]); [Courses.CourseShort])

So far so good; in the query I saw that the IIf worked.
When I run the module, it reads the query but it copies the Description to the .txt file but only the first 256 characters (incl. spaces) instead of the 2300 characters
Any suggestions, please help.:banghead:

 

[Harry_38]

Re: expressions in queries being truncated

I found the answer in: http://support.microsoft.com/kb/207668
ACC2000: Exported Query Expression Truncated at 255 Characters.

 

[SQL_Hell]

Hi Harry_38,

You posted this in the SQL server forum, but it is an Microsoft access question, not sure if you were aware of this?

 

[Harry_38]

Moderator: please move this issue to the correct place
Thank you.