spaces in object names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Spaces make it slightly more complex, as you'll have to bracket your names..
but it's a fairly trivial difference.
 
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
 
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.
Click to expand...
It is a bad habit, as you must use square bracktes:

[name with space]

whenever you want to use your objects.


mfG
--> stefan <--
 
Back
Top