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?????


:cool:ShadeZ:cool:

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

ABSOLUTELY NOT!!! I hate to equivacate:) It is also very poor practice to use special characters such as the shifted values on the top row of the keyboard and the shifted and unshifted keys on the right edge of the main typing keys.

Access is virtually unique in its acceptance of the use of these characters. But even though you can get away with this poor practice in naming Access objects, you cannot get away with using these names in VBA and will run into all sorts of difficulties while trying to code. In some cases VBA will replace the spaces and other special characters with underscores. So for example, you name a field Cust#. If you look at the control Name, you'll see that the # has been replaced with an underscore and the generated sub name will be -
Private Sub Cust__BeforeUpdate(Cancel As Integer)

Notice that there are 2 underscores between cust and before.

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.


:D

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

This Is very one sided does noone like Spaces,

:cool:ShadeZ:cool:

Claustrophobic programmers? :p

noone?

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

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.