Data Length greater than 255 Characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I solve the limitation of 255 characters for a field? I have
information that is anywhere from 660 to 1000 characters long that I need to
place into the field. Is there a way to link fields or some other solution?
 
Karl offers one approach, stuff it all into a Memo data-type field.

Depending on what the characters represent, you might need to break it up
into related fields/tables. Can you provide an example of the data, and a
description?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a database of picture books that I am using in elementary school to
help teach qualities of writing. Each book has entries in a field named
"notes" that list the qualities or crafts of writing that are demonstrated in
the book. It turns out that I had created the "notes" field as a Memo field
and forgotten about that option. In the form that references the database,
each quality shows up on a separate line in the notes field.
Now I am trying to create a way of looking up each of the individual
qualities in the "notes" field by clicking on it and having it reference an
explanation database with a field (memo-data?) that gives a fuller
description of the quality and how it is used.
I had forgotten about using the memo type field to increase the size of info
that can be included.
Do you have suggestions for how best to accomplish the overall task or this
individual field question?
 
When I'm faced with an "individual notes" situation, I create a table that
uses one row per note. Each row in that table gets (in my typical
situations) a field for a Date/Time stamp (when the note was written), a
field for the Writer (who's writing the note), and a field for the note
(usually 255/text is enough, since each "individual note" is now separated -
but a memo field could still be used, if necessary).

Does that fit your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top