devxlogo

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.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Seven Service Boundary Mistakes That Create Technical Debt

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.