By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,603 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Large text boxes

P: n/a
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?

Jan 20 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Ryker wrote:
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?


-----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-----
Jan 20 '06 #2

P: n/a
BB
Change the field type from Text to Memo. That gives you room for about
32,000 characters.

Jan 20 '06 #3

P: n/a
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?

Jan 20 '06 #4

P: n/a
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?

Jan 20 '06 #5

P: n/a
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];

Jan 20 '06 #6

P: n/a
Thanks, I will give that a try.

Jan 20 '06 #7

P: n/a
On 20 Jan 2006 13:12:37 -0800, "Ryker" <ra*****@choctaw.org> wrote:
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?


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.
Jan 20 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.