I think it is partly the 'fault' of Access which obliges when creating forms and reports etc. which will autopopulate the field name to the associated label.
New developers think 'great!, no need to do this twice, saves me time' - when in fact in the longer term it takes more time to resolved the resulting problems. They could use the caption property but hey, that means typing something in twice, so why bother...
If they have come from an Excel background, they are used to being able to put pretty much what they want in the column header which is typically not referenced by the content but it's location e.g. C1 or by counting columns. Since a datasheet view which is pretty much the first thing a new developer will see in creating a new table looks pretty much like a spreadsheet, the assumption is it is the same.
Wouldn't it be great if every time you create a field name or alias with spaces or non alphanumeric characters Access throws up a warning - it will be irritating enough for people to stop using them except where they felt it necessary.
