Do U use Spaces In Field Names????

[Shadez]

Ok quick poll for you Access Gurus

DO!!! you use [S P A C E S]!!!!! in ur field names

I personnaly dont use them they become anoying when doing SQL,

Whats ur opinion?????


ShadeZ

 

[Mile-O]

It's a better practice not to use spaces in any object whether it be a table, form, field, or a control.

 

[jfgambit]

I would suggest using spaces but only when you want to tick off the next Access programmer that comes along and needs to fix or change your DB.

Also, if you really want to get under their skin, make every other field name contain a space and the Primary Keys should be listed as "I D #". This can help to promote job security.

 

[RichMorrison]

Agree with those who don't use spaces.

I inherited an app from someone who did. This nameless person was not a careful typist. A few field names had 2 spaces between some words.

My old eyes had big problems with that.

RichM

 

[Shadez]

This Is very one sided does noone like Spaces,

ShadeZ

 

[Fornatian]

Claustrophobic programmers?

 

[neileg]

noone?

Peter Noone was leader of Herman & the Hermits. Don't know if he does much db programming these days.

 

[crosmill]

I work with a guy who sometimes uses my db's, whenever he add's tables or columns uses THIS SORT OF FORMAT26032003, where as I opt for MoreRelevantFormat it drives me mad, I code in SQL/VBA and ASP and it takes me about an hour longer to get the work done.

Also, coding across these langages you find somtimes it works and somtimes it doesn't. Keep it simple it makes eveyones life easier.