How do setup a note box in Access 2003?

[Guest]

I am very new to Access. I am setting up a database to track customers who
have maintenance accounts with my company. Everything has gone well to this
point.

The problem I am having is I would like to input a box into my form where
either myself or my coworkers can add dated notes onto the record. If I place
a text box on the form it requires me to bind it to a database field. Which I
dont want to do because of the limited number of characters.

So to get around this I left it unbound. The problem with this is that it
then changes in every record if you type anything into the text box.

Is there a way to set this up so that I dont have to have it change in every
record and it will be bound only to the record I would like that note to be
attached to?

 

[John Spencer]

If you add a field (type Memo) to your table, you can then enter over 32,000
characters via a textbox on a form.

If you don't have a field to store the data in, then the data exists only as
long as the form is open and if the control is unbound on a continuous form
there the control will show the same information for every record.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

There is no problem binding an Memo field to a text box control. The Input
Box is not a control on a form. It is a special Access object used to accept
data. Most professionals seldom if ever use one.

 

[Guest]

Thank you. That worked perfectly.

If you add a field (type Memo) to your table, you can then enter over 32,000
characters via a textbox on a form.

If you don't have a field to store the data in, then the data exists only as
long as the form is open and if the control is unbound on a continuous form
there the control will show the same information for every record.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thank you for your help.

There is no problem binding an Memo field to a text box control. The Input
Box is not a control on a form. It is a special Access object used to accept
data. Most professionals seldom if ever use one.