text Box

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

Hello All
I inserted a text box in my form, how can i set it to save for every record
ie I want the comments to stay on the record not to move to another
 
You mean you added an unbound text box (i.e.: no field was specified for its
ControlSource)? What you're seeing is standard: change the value in an
unbound control for a continuous form and every instance of that control is
updated.

You'd need to bind the text box to the appropriate field in the form's
RecordSource.
 
The form is bound to some table. Open that table in design view, and add
another field of type Memo or Text. Save. Close.

Now open your form in design view, and set the Control Source property of
the text box to whatever you called the new field. The data will be saved in
the field, so it will show up again when you open that record again.
 
Hi bill,
Hello All
I inserted a text box in my form, how can i set it to save for every record
ie I want the comments to stay on the record not to move to another
Click to expand...

You should add a textbox that is unbound.

Kind regards

Hans
 
The textbox needs to be bound to a comments field in your table or query that
is the recordsource for the form.
 
Back
Top