I want to add a Notes Box

K

Kim

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?
 
R

Rick B

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.
 
M

mscertified

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top