I have a form where "notes" are entered on an individual.
Unfortunately, these notes are usually longer than the 255 characters
allowed in a single text box. To get around this, I have three note
boxes set up on the form (note1, note2, and note3). When one fills up,
the user can tab to the next one and continue typing. This works but
it is very cumbersome and sloppy. Is there an easier way?

Ryker wrote:[color=blue]
> I have a form where "notes" are entered on an individual.
> Unfortunately, these notes are usually longer than the 255 characters
> allowed in a single text box. To get around this, I have three note
> boxes set up on the form (note1, note2, and note3). When one fills up,
> the user can tab to the next one and continue typing. This works but
> it is very cumbersome and sloppy. Is there an easier way?
>[/color]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use a Memo field instead of a Text field. A Memo field can hold about
65,000 characters. Note, that you can't GROUP BY a Memo field in a
query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9FHhoechKqOuFEgEQJAggCg8MOFOJ1yR/aalwsjckXNgDPk0icAn3PR
aVm9gISUsi39p8xh0nqNevtb
=cC6+
-----END PGP SIGNATURE-----

Change the field type from Text to Memo. That gives you room for about
32,000 characters.

Thanks, that works.

Is there a way to take the data that is in note1 note2 and note3 and
place it into the new memo field that I will be creating?

Thanks, that works. Now that I have my notes fragmented into other
note fields, is there a way to merge them into one memo field?

Assuming you tack on the memo field to the table with the three
existing 'note' fields, you can do:

UPDATE tblNotes SET tblNotes.MemoField=[note1] & " " & [note2] & " " &
[note3];

Thanks, I will give that a try.

On 20 Jan 2006 13:12:37 -0800, "Ryker" <rasmith@choctaw.org> wrote:
[color=blue]
>Thanks, that works.
>
>Is there a way to take the data that is in note1 note2 and note3 and
>place it into the new memo field that I will be creating?[/color]

Run a query and append the three note fields into the new memo field.
Also, the 65k character limit on memo fields only applies the amount
of characters you can actually type into a memo field. The actual
memo field in the table can hold MUCH more. Why this limit exists for
a text box bound to a memo field is a mystery.