Naming conventions

[amanco]

(1) What characters i should not use in Fields names, as i realized when working with VBA some characters are not recognized and substituted with (_)?

(2) is it ok if i add underscore (_) in table's and form's names?

(3) any hints about naming? like for a text box field we use txt

(4) any good articles to read?

thank you

 

[Navyguy]

NamingStuff

I got this from a post in the forum where I had similar questions.

http://support.microsoft.com/defaul...port/kb/articles/q173/7/38.asp&NoWebContent=1

This may also be helpful...

http://support.microsoft.com/default.aspx?scid=kb;en-us;209187&Product=acc

 

[Mile-O]

(1) What characters i should not use in Fields names, as i realized when working with VBA some characters are not recognized and substituted with (_)?

(2) is it ok if i add underscore (_) in table's and form's names?

(3) any hints about naming? like for a text box field we use txt

(4) any good articles to read?

1. Preferably, all characters but alphanumerical characters.
2. It is okay but not advised. It's a better practice to elimiate all breaks in words and capitalising the first letter of each word in an object's name thus, rather than frm_My_Special_Form, you have frmMySpecialForm.
3. Read the article NavyGuy has posted. It contains the most commonly used conventions.
4. See 3.

 

[amanco]

thank you guys that really helps