By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Is Name a reserved word?

P: n/a
I ask because, in Access help, it does not list is as such, however, I had a
table with a field named 'Name'. If I put a control on a form and used this
as the control source no problems, but if I used the field in a calculated
control, i.e... =Trim([Name]) ... the control would display the name of the
form. Error in help documentation?
Oct 9 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 09 Oct 2006 02:10:18 GMT, Robert wrote:
I ask because, in Access help, it does not list is as such, however, I had a
table with a field named 'Name'. If I put a control on a form and used this
as the control source no problems, but if I used the field in a calculated
control, i.e... =Trim([Name]) ... the control would display the name of the
form. Error in help documentation?
Yes. It is a reserved word.
See the following knowledge base articles for more reserved words.
In addition to those listed in the article, avoid any word which is
also an access property, i.e. Height, Width, etc., even if not listed
in the articles.

For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 9 '06 #2

P: n/a
Robert wrote:
I ask because, in Access help, it does not list is as such, however, I had a
table with a field named 'Name'. If I put a control on a form and used this
as the control source no problems, but if I used the field in a calculated
control, i.e... =Trim([Name]) ... the control would display the name of the
form. Error in help documentation?
Funny you should ask this question. We just had a discussion on it in
another thread.
http://groups.google.com/group/comp....7c83d7f08ddd56
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 9 '06 #3

P: n/a
On Mon, 09 Oct 2006 02:10:18 GMT, "Robert" <no**@none.comwrote:
>I ask because, in Access help, it does not list is as such, however, I had a
table with a field named 'Name'. If I put a control on a form and used this
as the control source no problems, but if I used the field in a calculated
control, i.e... =Trim([Name]) ... the control would display the name of the
form. Error in help documentation?
Hi
yes, but this is a moving target because as time moves on eventually all words will be
given some system meaning. That is one reason to follow one of the naming conventions
which use prefixes to private names. Also, if and when you move to a different back-
end database you will have extra reseved words to avoid.
Oct 9 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.