Limit in Text Box

[ChelseaS]

Hello,
I'm having an issue with the amount of characters allowed in a text box. I
need to be able to have a space that allows more than 255 characters. How can
this be accomplished? I am not too savvy with Microsoft Access yet, so any
response written in lay-mans terms is greatly appreciated!
Thankyou!

 

[Gina Whipp]

ChelseaS,

In the table change the Data Type to Memo.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Linq Adams via AccessMonster.com]

As Gina has said, if you need a field to hold more than 255 characters you
need to use a Memo field, which can hold in excess of 64K.

But you should know, if a database is set up properly, text fields seldom
need to be more than 255 characters long. One of the Cardinal rules to having
a well designed, normalized database is that no single field will contain
more than one individual piece of data.

Data stored in Memo fields should be restricted to "notes" or narrative type
information, such as a salesman's notes on a customer visit or a doctor's
progress notes on a patient.

Working primarily in a Heath Care environment, I've used Memo fields
extensively for a number of years, without ever having a problem. The secret
is to follow one simple rule:

Never, never, never place data in a Memo field if there any possibility that
you will ever need to search, sort, parse or in any other way manipulate the
data!

Because many queries perform some of these functions, you have to take care
in using them in queries or they will be truncated to 255 characters. Allen
Browne has an excellent article explaining how to deal with Memo field and
queries:

http://allenbrowne.com/ser-63.html

Good luck!

 

[Mr. B]

Set your field type to Memo instead of Text. A memo type field will allow
over 65,000 characters.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm