Text Box Fields larger than 255 characters

[Justin]

How do you use text fields, that are, in effect, larger
than the 255 character limit, in forms reports and
everything else.

 

[Dorian]

Use a memo field.

 

[John Vinson]

How do you use text fields, that are, in effect, larger
than the 255 character limit, in forms reports and
everything else.

By using Memo fields instead of Text fields in your table definition.

 

[Jeff Boyce]

Justin

It depends on what you are trying to accomplish. Other responders have
already pointed out that you can use a memo-type field to hold more
characters. You give up indexing when you do that.

Another approach might be to break the text into multiple records (of type
text). So, instead of jamming all your comments into one memo field, you
create a one-to-many relationship with a "Comments" table, and have each
comment limited to text-field size (255), but also have the date, the person
recording, the ambient air pressure, or any other relevant fields.

Good luck

Jeff Boyce
<Access MVP>