Free Text

Hi again...

I have just downloaded a template from office online for a simple customer
database, and i want to a add a free text box at bottom of screen. I have
done this however when i type in the box it copies it too ALL the other
records... How do i stop it doing this?.....

Thanks in advance for any assistance

In article , "=?Utf-
8?B?R2FyeSBTY290dA==?=" Gary says...
Hi again...

I have just downloaded a template from office online for a simple customer
database, and i want to a add a free text box at bottom of screen. I have
done this however when i type in the box it copies it too ALL the other
records... How do i stop it doing this?.....

Thanks in advance for any assistance


The text probably is not being copied to all the records - rather, it
may not be saved in ANY record, and just displaying on your form while
the form is open. If this is the case, then your new field is
"unbound". Make sure you've added a text or memo field to your customer
table. Then, in design view of your form, open the Properties of your
textbox and set it's Control Source to the name of the new field in your
table. This will now be a "bound" field - it's bound to the field in
your table.

In the future, after you add a new field to a table, you can just drag
it onto your form from the field list while in the form's Design view.
This will set the Control Source for you.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/AS...jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

Armen

Your a star!!! thanks...... its easy when you know how!!!!

Many thanks.

gaz


"Armen Stein" wrote:

In article , "=?Utf-
8?B?R2FyeSBTY290dA==?=" Gary says...
Hi again...

I have just downloaded a template from office online for a simple customer
database, and i want to a add a free text box at bottom of screen. I have
done this however when i type in the box it copies it too ALL the other
records... How do i stop it doing this?.....

Thanks in advance for any assistance


The text probably is not being copied to all the records - rather, it
may not be saved in ANY record, and just displaying on your form while
the form is open. If this is the case, then your new field is
"unbound". Make sure you've added a text or memo field to your customer
table. Then, in design view of your form, open the Properties of your
textbox and set it's Control Source to the name of the new field in your
table. This will now be a "bound" field - it's bound to the field in
your table.

In the future, after you add a new field to a table, you can just drag
it onto your form from the field list while in the form's Design view.
This will set the Control Source for you.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/AS...jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com