
Want Insert into meno fields ( including Nextline character)
Quote:
>Hi,
>I have a problem which I couldn't solve.
>I have a sql statement which contains next line character...
>when I use de{*filter*} to print out the sql statement, I can see the
>whole formatted text.
What are you using as the "nextline character"? In Windows, it's *TWO*
characters: Chr(13) followed by Chr(10), a carriage return and a
linefeed. There is a
VBA constant vbCrLf (or, equivalently, vbNewline)
you can use to insert it. Typing Ctrl-Enter while manually entering
data, or setting the "Enter Key Behavior" property of a textbox to New
Line In Field, inserts this.
Quote:
>but after I run the sql statement by using
>currentdb.execute strSql
>When I read that field from the form or table or copy the meno field
>from table and past to notepad, it shows me the text without nextline
>character...
Sounds like you might be inserting just a linefeed (Chr(10)) or just a
carriage return.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://www.*-*-*.com/