View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jess Jess is offline
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