If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access text box
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? |
#2
|
|||
|
|||
Access text box
On 25 mrt, 12:19, FernP wrote:
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 |
#3
|
|||
|
|||
Access text box
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? -- Daryl S "FernP" wrote: 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? |
#4
|
|||
|
|||
Access text box
On Thu, 25 Mar 2010 04:19:01 -0700, FernP
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|