Referencing "two word" fields 1

[sepia]

How do you reference a field that it's name consist of two words in a expression (ex: "First Name&quot? Thanks!

 

[AccessSQLUser]

enclose it in brackets []

 

[THoey]

The prior answer is correct, but I couldn't help but add the rest of the standard reply. It is consider a good practice to carefully name your database tables, fields, queries, modules, etc. I constantly see people who use two words or Access reserved words in their naming conventions. This usually ends up causing more problems / confusion than almost anything else.

-- Be aware of Access's reserved words and don't use them by themselves.

-- If you are going to name a field "First Name", use an "_" to separate the words as in "First_Name".

Another tip is to make sure you give the controls on your forms meaningful names. "txtFirst_Name" makes a lot more sense than "textbox134".

Just my two cents... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.