LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing character in a string MikeL Excel Discussion (Misc queries) 2 December 3rd 09 08:11 PM
Validation a character in a string coolmale001 Excel Discussion (Misc queries) 1 October 10th 09 12:55 PM
find a character in a string kevcar40 Excel Discussion (Misc queries) 4 June 5th 07 12:10 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
Does the cell contain the character "-" within the string? Eric Excel Discussion (Misc queries) 4 December 3rd 06 03:46 PM


All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"