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: 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!
 
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
Problem searching cell text tommcbrny Excel Discussion (Misc queries) 3 May 15th 08 05:00 PM
conditional formatting - problem with text cell value from formula PBcorn Excel Worksheet Functions 2 April 18th 08 11:39 AM
Fitting text into a cell problem. Please help! Natty Excel Discussion (Misc queries) 3 December 14th 07 03:27 PM
Inserting Long Text in a Cell Problem Suh, Suk Ho Excel Programming 0 August 15th 03 06:58 PM
Inserting Long Text in a Cell Problem Keith Willshaw Excel Programming 0 August 15th 03 12:39 PM


All times are GMT +1. The time now is 08:55 AM.

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

About Us

"It's about Microsoft Excel"