I've been programming for almost all my life and I've got some deep habits when it comes to programming and as I'm just starting out in Access I'm wanting to get things right now to save me a massive headache later on.
Every language I've used has no spaces in variable names. Al my tables and fields in MySQL all contained no spaces and I had a strict naming convention to help tell things apart. For example, a field in a table which was linked to the primary key in another table always started with an underscore.
How does spaces in field names affect the use of variables when programming and am I best to strip them all out?
for example, in one table I've got field names like "Property ID", "Agent ID", "Post Code", "Gas Checks Required" and so on.