spaces in object names

[MaRSMAN]

Is it best to not leave have a space between names of tables or forms or
fields or querys or repoerts. ex: tablename or table name fieldname or
field name etc.
Therfore using the caption to clarify the table, field etc. Is one way
better for writing
sql or code or expression, calculations.
Thank you. The Lord's Blessings on your day

 

[Lance]

Spaces make it slightly more complex, as you'll have to bracket your names..
but it's a fairly trivial difference.

 

[Jerry Whittle]

Personally I don't recommend spaces or any other special character except the
underscore " _ ". Just the 123's and ABC's. That way you never need brackets.
My object names look something like My_Table_Name or MyTableName. Using upper
case first word letters help readibility.

I also don't like the caption property as it makes it difficult to
troubleshoot as the caption isn't readily visible. I either change things in
the query or in the labels in forms and reports. In a query it would look
something like:

First Name: First_Name

 

[Stefan Hoffmann]

hi,

Is it best to not leave have a space between names of tables or forms or
fields or querys or repoerts. ex: tablename or table name fieldname or
field name etc.
Therfore using the caption to clarify the table, field etc. Is one way
better for writing
sql or code or expression, calculations.

It is a bad habit, as you must use square bracktes:

[name with space]

whenever you want to use your objects.


mfG
--> stefan <--