Forum Discussion
ACCESS field name error message
go to the end of the pasted text and use Backspace until you can delete a "normal" character.
Unfortunately, I can't replicate the error situation you described, although Access does reject the use of an ellipse in a field name.
You can find more information on good naming conventions here.
- Thanks. I figured that was the input problem. That seemed to be the only error pop-up that froze the program. I reviewed allowable input data and hopefully won't see it again
- Now I'm a bit confused again. Are we talking about "input data" or "field names"?
So both Arnel and I are right in that you tried to use invalid characters for a field name in a table, albeit in a different way than maybe it first appeared.
You should now be aware that some names, such as "Date", which are names used by Access itself, should not be used as field or object names.
You are also now aware that non-standard characters, such as the ellipsis, or "three dots", are not valid either. You probably should invest a bit of reading time on the subject of proper naming conventions for Access. Use your favorite search engine and read some of the discussions about it.
In this case, it is a bit surprising, in one way, that the problem you encountered with the ellipsis resulted in that level of difficulty, but in another, given what the ellipsis is normally used for, I can see Access being unable to properly handle it in an error situation. I'll do some testing as well.
