See correction below. 254 is the max length of a character field. You should also limit the lenght of the test in editbox by setting MaxLenght Property to 254.

>I changed a textbox with data type c(20) to an editbox with data type m(4) so the user could add a longer description. I use the following SQL to create a cursor that is used to create an Excel file (COPY TO (filevariable) TYPE XL5)
>

>SELECT log,requestor,division,memdate,datexxrecd,divrefnum, ;
>	section, <b>PADR(comments,254)</b> AS comments,status, ;
>	rettodate,retfromdat,indate,datecomp ;
>	FROM flair1 ;
>	WHERE STATUS=0 ;
>	INTO CURSOR samData ;
>	ORDER BY division,LOG
>

>Now the memo field "comments" only contains the first letter of the string in the memo field. How do I get the whole string so I can send it to Excel or what is the best way to pass memo field to Excel?
>
>Thanks in advance, Chuck