VBA To Use Fields With Names

[jo15765]

I do not have any fields with names in them, but I was reading and saw this and was curious which one is proper protocol? Do both of these mean the same thing?



Let's say we have a field whose name is Field One - what is the proper way to reference this field using VBA

Me![Foo ID]
Me.Food_ID

Both of these work, but to me it is just as annoying as adding an underscore as it is having to add square brackets. Obviously the moral of the story DO NOT use field names with spaces, but what would be the proper way to code if it is done?

[jwhite]

"Bang vs. Dot"
http://www.utteraccess.com/forum/Per...t-t103870.html

If you are forced to use field names that have spaces in them, then [ ] around the field name would be required in both queries and within VBA code.

[jo15765]

"Bang vs. Dot"
http://www.utteraccess.com/forum/Per...t-t103870.html

If you are forced to use field names that have spaces in them, then [ ] around the field name would be required in both queries and within VBA code.

Thanks for the response. I do not use spaces in field names, but saw that both were an option to account for spaces. I was curious which was the "right" way to do do this.

[ItsMe]

Use the dot operator as an Access Operator to access an object's members. Use the Bang to reference only the default member.
http://bytecomb.com/the-bang-exclama...erator-in-vba/

Behind a form, use the following to access a control named My Control ...
Me.My_Control.Value
Me.[My Control].Value

Behind a bound form, use the following to access a field within a column named MyField ...
Me!MyField
Me![MyField]