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.
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.
#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].
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2000 new field
#Name?
for this field in each record but it should be blank.
Any ideas about what we are doing wrong?
- Dawn