#Name?

  • Thread starter Thread starter dpk4545
  • Start date Start date
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
 
How do I get ride of this error messgae?
Click to expand...

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.
 
Jeff Boyce said:
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
Click to expand...
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?,
 
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?,
Click to expand...

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

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