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

Reply With QuoteReply With Quote