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

  • Thread starter Thread starter hvtrang
  • Start date Start date
H

hvtrang

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA formula strings longer than 255 characters 3
ADO help: Only get first 255 characters of field... 2
Limit textbox to 255 characters 2
How to find row with more than 255 characters in a cell 4
Opening Word Docs from Excel VBA With full path and name > 255 chars 0
copy cells with more then 255 chars... 7
UDF Can't return more than 255 chars??? 3

Back
Top