Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Chart with different beginning values | Charts and Charting in Excel | |||
eliminate space at beginning of line | Excel Worksheet Functions | |||
Sort beginning one-line BELOW what should be | Excel Programming | |||
How do I calculate the Root Mean Square (RMS) of line of equality | Excel Discussion (Misc queries) | |||
Line break in cell, char(10) square settings? | Excel Programming |