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!

Problem with text in cell
 

I am using this code, not the .Text:
xlsWorksheet.Range(cellRef).Value= tmpString

"JWS315" wrote:

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!

Problem with text in cell
 

hi,

the string type is limited to 255 chars, however i always limit it to 250 to
avoid exchange problems with other databases
--
Kind regards
Noëlla


"JWS315" wrote:

I am using this code, not the .Text:
xlsWorksheet.Range(cellRef).Value= tmpString

"JWS315" wrote:

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!