#Name?

[dpk4545]

How do I get ride of this error messgae?

 

[Jeff Boyce]

Spell.

When Access says "#Name", it doesn't recognize the spelling.

Access is VERY literal ... if you have:

frmYourFirstForm

and

frmYourFisrtForm

Access will not "know" you meant the same thing.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

How do I get ride of this error messgae?

By correcting the error in your form or report.

If you would like help doing so please post some information that a volunteer
could use to help diagnose the problem. We can't see your database from here.

 

[dpk4545]

Spell.

When Access says "#Name", it doesn't recognize the spelling.

Access is VERY literal ... if you have:

frmYourFirstForm

and

frmYourFisrtForm

Access will not "know" you meant the same thing.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for your reply. We are creating a form with contact details. In
design view , the name "Contact Details" is correct - (including spelling).
However, when we leave design view, the name appears as #Name?. Any
suggestions?,

 

[fredg]

Thanks for your reply. We are creating a form with contact details. In
design view , the name "Contact Details" is correct - (including spelling).
However, when we leave design view, the name appears as #Name?. Any
suggestions?,

Because you have that space in the field name you must enclose the
name within brackets:
[Contact Details]

Best to never use spaces. ContactDetails is just as easy to read as
Contact Details.

 

[John W. Vinson]

Thanks for your reply. We are creating a form with contact details. In
design view , the name "Contact Details" is correct - (including spelling).
However, when we leave design view, the name appears as #Name?. Any
suggestions?,

The name of... what? A Form? A Subform? A control? Where is the #Name?
appearing?