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: 60
Default Square before beginning of a new line

I have an access database which generates an excel document. The excel sheet
is populated from text boxes on an access form. These access textboxes can
accommodate multiple lines.

When the content of a given multiline access textbox is placed into an excel
sheet, a square can be observed just before the beginning of a new line. I
would to keep the multiline structure in the cell without the square.

I have noticed that each line is created with chr(13) & chr(10).

The square only disappears if I completely remove chr(13) & chr(10) with the
replace function. However this gets rid of the new line too.

How can I get rid of the square while keeping the multiline structure in the
excel cell?

Thanks


 
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
Line Chart with different beginning values DuaneS Charts and Charting in Excel 1 July 28th 07 02:05 AM
eliminate space at beginning of line Finger Tips Excel Worksheet Functions 1 June 1st 07 12:55 AM
Sort beginning one-line BELOW what should be Jim May Excel Programming 10 January 21st 06 03:13 PM
How do I calculate the Root Mean Square (RMS) of line of equality aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa Excel Discussion (Misc queries) 1 June 23rd 05 12:22 PM
Line break in cell, char(10) square settings? Fredrik Jansson Excel Programming 3 October 14th 03 01:37 PM


All times are GMT +1. The time now is 09:37 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"