General discussion

Locked

Access 2000 new field

By support ·
We have an existing Access 2000 database program which the user has added a new text field to. Initially we didn't see the new field when trying to add it in a text box on our subform in design view but if we go through the tables manually we can add the field. However when we get out of design view we see:
#Name?
for this field in each record but it should be blank.
Any ideas about what we are doing wrong?
- Dawn

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 new field

by donq In reply to Access 2000 new field

Your designer probably did the correct thing and attached your "Form" where the invisible "Field" shows up as #Name?.

Check the Form's Record Source Property to insure the Fields container is pointing to the proper data source (Table or Query based on the table). and check the Fiels'd Row source property to verify you're looking in the coerrect table column.

In either case your proplem is likely a simple property setting.

Collapse -

Access 2000 new field

by support In reply to Access 2000 new field

Poster rated this answer

Collapse -

Access 2000 new field

by mbarker734 In reply to Access 2000 new field

#Name? appears in a control.

#Name? may appear in a control for a number of reasons. To correct the problem, do the following:

? Make sure that the field specified in the control's ControlSource property hasn't been removed from the underlyingtable, query, or SQL statement.

? Check the spelling of the field name in the control's ControlSource property.

? If you specified an expression in the control's ControlSource property, make sure that there is an equal sign preceding the expression.

? Make sure that there are brackets around references in expressions to control or field names that include spaces. For example, to subtract a Shipped Date field from a Required Data field, enter the following expression: =[Required Date]-[Shipped Date].

Good luck,

Mark

Collapse -

Access 2000 new field

by support In reply to Access 2000 new field

Poster rated this answer

Collapse -

Access 2000 new field

by yatst In reply to Access 2000 new field

You need to refresh the data source.

Go to properties for the form. If the data source is directly to a table. . . Select a different source go the all tab. Go back to the data tab and reselect the correct data source.

If the data is from aquery built at the form. . .Click on the three dots next to the data source. THis will open the query (that you cannot see from the query tab). Add the new field to the query. Close and save and return to the form.

Chances are answer number is the most likely culprit.

Collapse -

Access 2000 new field

by support In reply to Access 2000 new field

Poster rated this answer

Collapse -

Access 2000 new field

by support In reply to Access 2000 new field

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums