How to add a field in Design view

R

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
 
F

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
Click to expand...

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.
 
R

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
 
F

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
Click to expand...

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.
 
Top