I want to add a Notes Box

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

Guest

I want to add a notes box but when I do it will only accept a few characters.
I need to be unlimited - Can anyone help?
 
Well, not unlimited, but you should probably set it to a "memo" field if you
will need more than 250 characters for each note entry.

Typically, you would store notes in a separate related table and each record
in that table would have the related record number (customer number,
employee number, etc.) the memo field, a date and time.

Every time a new "note" is added to the database, it is done by creating an
new record in that table.

Many of the templates that ship with Access include this layout. You could
use one of those as your guide. The contact management template has a
"calls" table and form that is a great example of this.
 
Just make the control bigger by dragging the borders .
Your bound column should be defined as datatype 'Memo'
However even that is not 'unlimited'
Look in Access Help to see the limits of a Memo field

-Dorian
 
Back
Top