Help Me!!. can not set the string with len more than 255 character to the value cell
 

i have an access file,in this i have a table, and have a memo field i
this. which field have a string less than 255 char it ok, but whic
field more than 255 char it display #value! in exel file. How can i fi
this problem.
i use this command in VBA to set value:
ExlObj.ActiveSheet.Cells(NxtLine, lc + 2).Value
rsDailyReport.Fields(lc)

thanks

--
Message posted from http://www.ExcelForum.com

Help Me!!. can not set the string with len more than 255 characterto the value cell
 

I don't speak Access, but Debra Dalgleish posted this to a similar (well, it
sounded similar to me!) request.

http://groups.google.com/groups?thre...resXSPAM .com

Maybe it'll help you???


"hvtrang <" wrote:

i have an access file,in this i have a table, and have a memo field in
this. which field have a string less than 255 char it ok, but which
field more than 255 char it display #value! in exel file. How can i fix
this problem.
i use this command in VBA to set value:
ExlObj.ActiveSheet.Cells(NxtLine, lc + 2).Value =
rsDailyReport.Fields(lc)

thanks.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson