How to add a field in Design view

[Rock]

Hi,

In Access 2002 I have found out I need another field or two in my new
table but I have just finished the form set up.

I have read the Help but my Insert Menu does not have the necessary
options it suggests..

Any help please?

John

 

[fredg]

Hi,

In Access 2002 I have found out I need another field or two in my new
table but I have just finished the form set up.

I have read the Help but my Insert Menu does not have the necessary
options it suggests..

Any help please?

John

Simply open the table in design view.
Add the new fields.
Save the changes.

If the table is the record source of the form, open the form in design
view. Click on the field List tool button. drag the new fields onto
the form. Save the changes.

If a query is the form's record source, add the new fields to the
query, then open the form in design view and proceed as above.

 

[Rock]

Thank you..

What I actually meant was I need an extra fuiled that is NOT in the list
of fields or anywhere else. It is an extra one I need to put in the
middle of the form.

John

 

[fredg]

Thank you..

What I actually meant was I need an extra fuiled that is NOT in the list
of fields or anywhere else. It is an extra one I need to put in the
middle of the form.

John

A FIELD is an object in a table that stores data.
It appears that you wish a CONTROL on your form that is not going to
have it's data stored.

Click on the ToolBox (the hammer and wrench icon) toolbutton.
When it opens, click on the text control tool button(it says Ab|).
Move your cursor to the form and drag it.