Text Boxes

[Guest]

I have imported an excel spreadsheet into Access. I have created forms and
reports which use this data and I have added a text box to the form so that I
can print each individual record and add written notes. If I transcribe my
notes from one record back onto its form they appear on the form for every
record. How can I make notes apply to only the record I am looking at and
add different notes for each record.?

I am really new at access, so be gentle ok!

Many thanks

 

[Ken Snell \(MVP\)]

You'll need to give us more details about the structure of your form and the
record source that you're using for it.

My first thought is that the textbox into which you're putting the notes is
unbound (has no control source field), so a continuous forms view for your
form will show the same result for all records. Do you have a field in the
original table that will hold the notes data for each record?

 

[Guest]

Hi Ken,

The text box on the form does say unbound in it and i tried to explore
binding it, but got very confused. No I do not have a field in my original
table for notes. I imagine this field would be very large as the notes can
be several hundred characters. and there might be more to add at a later
date. There are 26 fields per record at the moment.

I don't really know how to tell you about the structure of the form. I
designed it using the wizard from the fields on the table.

Thanks..

 

[Ken Snell \(MVP\)]

Add a field to your table -- set its Data Type to Memo. That will hold over
65000 characters in the field. Then include that field in your query's
output fields so that the form can "see" that field. Then bind your textbox
to that field in the form.