Need to use a textfield with many rows for my database

[Mikael Lindqvist]

Hi everyone,

This is probably a universal problem since textfield is restricted to 255
bits.

Now, I need to create a database (and form) that allows user to input a lot
of text (a sort of "comment logg").

I'm sure there's a ready solution to this but I can't find it. Guess I need
to use an external textfile... but how can I set it up so that the Form input
ends up in the textfile, and the text itself can be loaded by queries?

Kindly,
Mikael
Sweden

 

[Jeff Boyce]

Mikael

A "memo" data type field can hold 65,000+ characters, where the text type is
limited to 255.

In my situations, I create a "many" table and put one comment in each row
(date/time, writer, comment, and "connected to" fields).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Mikael Lindqvist]

I understand, but how do you deal with line breaks, is that possible? Or do I
have to accept "continious" text without line breaks?

Cheers,
Mikael

 

[Jeff Boyce]

Mikael

When I'm using the one-(text)comment per record approach, I limit the
comment to 255 characters. Line breaks might come in more for the
memo-field approach. I think (test this yourself) I use Ctrl-Enter to
insert a "carriage return".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Bob Quintal]

=?Utf-8?B?TWlrYWVsIExpbmRxdmlzdA==?=

I understand, but how do you deal with line breaks, is that
possible? Or do I have to accept "continious" text without line
breaks?

Cheers,
Mikael

One property of a textbox on a form is titled Enter Key Behavior.
there are two options, Default is the first, New Line in Field is the
second.

That should be self-explanatory.