correct field/table/query naming

[Rusty Shackelford]

I was told not to have spaces in names so I have always put a - between
words. Now while making modules when I input the name of the report or
whatever such as "memo-report-send" the module reformats it as "memo -
report - send". I tried using " around and it did not work is there a way to
make it take the name as a literal? And did I make a huge mistake in my
naming conventions? Is there a guide to naming in Access?
Thanks,

 

[John Vinson]

I was told not to have spaces in names so I have always put a - between
words. Now while making modules when I input the name of the report or
whatever such as "memo-report-send" the module reformats it as "memo -
report - send". I tried using " around and it did not work is there a way to
make it take the name as a literal? And did I make a huge mistake in my
naming conventions? Is there a guide to naming in Access?
Thanks,

Unfortunately, you did err: hyphens are even more special characters
than blanks. I would suggest changing them to the innocuous Underscore
character, or using a capitalization convention such as
MemoReportSend.

 

[Roger Carlson]

As John said, if you must use something, use an underscore
(memo_report_send). Most of the time I use capitalization (MemoReportSend).
Don't dispair, however. There is a great shareware tool called Rick
Fisher's Find and Replace that will help you rename everything globally.
You can find it here:
http://www.rickworld.com/download.html

 

[Rusty Shackelford]

What about fields is it a no no to use them in the fields also?

 

[John Vinson]

What about fields is it a no no to use them in the fields also?

I wouldn't, FWIW. It might work but Access does WIERD things with
hyphens (even in data - note that "A-1234" and "A1234" sort as if they
were identical).

 

[Rusty Shackelford]

Thankyou

I wouldn't, FWIW. It might work but Access does WIERD things with
hyphens (even in data - note that "A-1234" and "A1234" sort as if they
were identical).