Access text box

[FernP]

I was trying to add text boxes to my database in form design view, which
worked fine up until the moment when i was back in form or table view. For
some reason when I add detail in one of the cells of the new column it was
automatically copied to every other cell in that new column. This has only
been happening with the new columns and the ones I created using the wizard
when starting the database seem to be working fine. What can I do about this?

 

[XPS350]

I was trying to add text boxes to my database in form design view, which
worked fine up until the moment when i was back in form or table view. For
some reason when I add detail in one of the cells of the new column it was
automatically copied to every other cell in that new column. This has only
been happening with the new columns and the ones I created using the wizard
when starting the database seem to be working fine. What can I do about this?

I think you added the fields to the form only, not to the table the
form is based on.
If you intend to store the data, you add the field(s) to the table
first and then update the form.


Groeten,

Peter
http://access.xps350.com

 

[Daryl S]

FernP -

How did you add the new text boxes? Is there a default value? What is the
control source? Is there any event code that references the new text boxes
or that is run on events of the new text boxes?

 

[John W. Vinson]

I was trying to add text boxes to my database in form design view, which
worked fine up until the moment when i was back in form or table view. For
some reason when I add detail in one of the cells of the new column it was
automatically copied to every other cell in that new column. This has only
been happening with the new columns and the ones I created using the wizard
when starting the database seem to be working fine. What can I do about this?

You've made a very common mistake: confusing data *storage* with data
*presentation*.

Data is stored in tables, and ONLY in tables. A Form or a Textbox isn't a data
storage medium, it's a display tool - a window which lets you see data stored
in the Table. If (as you have done) you add a textbox to a form without any
connection to a table, it's not tied to any data, so you will see it repeated.

You'll need to open the Table in design view, and add your new fields to the
table; you can then open the Form in design view and open its Recordsource
query. Add the new fields to the query. You will then be able to "bind" the
new textboxes to the new field by setting the Control Source property of the
textbox.