J
Justin
How do you use text fields, that are, in effect, larger
than the 255 character limit, in forms reports and
everything else.
than the 255 character limit, in forms reports and
everything else.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dorian
Use a memo field.
J
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.
J
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>
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>