correct field/table/query naming

  • Thread starter Thread starter Rusty Shackelford
  • Start date Start date
R

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,
 
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,
Click to expand...

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.
 
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
 
What about fields is it a no no to use them in the fields also?
Click to expand...

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).
 
Thankyou
John Vinson said:
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).
Click to expand...
 
Back
Top