Re: How to insert linefeed into the text of the Access table

"?????" <@discussions.microsoft.com> wrote in message
news:6495C1D2-2F24-4BB5-8C86-6B2283C0EF33@xxxxxxxxxxxxxxxx
>I want to insert linefeed into the Access table using ADO.
> I tried something like below:
>
> sText = sText & Chr(10) & "AAA"
> com.CommandText = "UPDATE tableX SET columnA = '" & sText & "' WHERE .. "
> com.Execute
>
> I finally want to show the linefeed on the report which is produced from
> this table.
> But this does not seem to work. Linefeed is not inserted in the table at
> least by looking.
> When inserting linefeed from a form, or Cut&Paste the text from other
> application, it works well, but I need to insert linefeed from a program.
> How
> can I do this?
>

Have you tried...

sText = sText & Chr(10) & Chr( 13 ) & "AAA"

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.

Relevant Pages