Best control to use for medium length text entry

X

XP

Using Office 2003 and Windows XP.

I need to place a control on a form that will allow users to enter comments
which may be up to 3 or 4 paragraphs of 2-3 sentences each.

Do you use a List Box, an expanded Text Box, or some other control for this?

What's best? Advantages? Disadvantages?

Thanks much for your input.
 
M

Mr B

You would need to use a TextBox in your form, but more importantly, you would
need to have the field in your table defined as a "Memo" type field to
accomodate the amount of text you want to allow uses to enter.

One more thing, after you place your textbox on your form, be sure to go to
the properties of the textbox and set the "Enter Key Behavior" property to
"New Line in Field." This will insure that your uses can just press the
Enter key to start a new paragraph in the text box.
 
M

Mr B

Display the properties of the textbox. Click on the "Other" tab. The sixth
row down is the "Enter Key Behavior" property.
 
M

missinglinq via AccessMonster.com

And just be aware, XP, memo fields are fine when used for entering such
things as comments as you've indicated, but Access queries don't like them!
As long as you don't decide later to try data manipulation with them, you'll
be OK. But doing such things as sorting by them or searching them for text
strings will, in all probability, land you in a mess! Many types of queries
will truncate them to 255 characters. Here's a collection of things Access
does to them, from a file I have named MemoFieldAngst:

Crosstab queries, Summary queries, Union queries, and Queries that use
Distinct
or DistinctRow will all truncate a memo field to 255 characters so Access can
perform the required functionality of eliminating duplicates.

Also, if you have specified a format in the field's Format property, this
will often truncate the data to 255 characters as well.

If Unique Value Property is set to Yes, Access has to compare the values and
once again Memo Field values are truncated.
 
Top