View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JWS315 JWS315 is offline
external usenet poster
 
Posts: 2
Default Problem with text in cell

I am creating an Excel worksheet from data in an Access table. I have a text
field in Access that I use to populate a cell in the worksheet but only part
of the characters are populated, the last few characters are dopped. Is
there a limit in the number of characters in a cell or am I doing something
wrong? Here is the code that I use:

cellRef = "G" & recNum
xlsWorksheet.Range(cellRef).Text = tmpString

tmpSting holds the value from the Access db and is a String type.

Thanks for any help!