devxlogo

Using Field Names With Spaces

Using Field Names With Spaces

Question:
I have an established Access v2.0 database with fields intables named “Circuit ID”, for example. How can I use VB v3.0 to query this database without changing all references to that field to “Circuit_ID”?

Answer:
Just enclose the field name in square brackets. Doing that will allow you to use spaces and other characters in the field names.

devx-admin

Share the Post: