Thread: Help Me!!. can not set the string with len more than 255 character to the value cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default 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

Reply With QuoteReply With Quote