"kieran" <kieran5405@hotmail.com> wrote in message
news:b39796b3.0410041029.5fd8efbc@posting.google.c om...
> Hi,
>
> I have a form which is submitting into a sql server db. i have one of
> the fields set to ntext which says length of 16. when i insert info,
> it only sumbits about a paragraph and when i pull this back using
> analyser it amounts to a byte count of 256 bytes. i thought you could
> submit pages of info using ntext??
>
> i had been trying to use varchar with a length of 7000, but for some
> reason only info on the one line is submitted. if the user uses a
> line break, then nothing after that is submitted.
>
> Any help greatly appreciated.

You may have a data type problem or you may have a problem with your
front-end, either in how the input data is handled or in how the output data
is displayed.

For instance, Access grids seem to ignore anything after a line break by
default. You may have successfully stored multiple lines of text (a string
with embedded cr/lf s) but then be unable to display anything after the
initial cr/lf by opening the table in MS Access.

You're going to have to look at the whole system involved (front-end tools,
database server, table defnitions, etc) to isolate the cause of your
problem.