Bracketed Field Names

[JamesJ]

How the heck do I prevent Access 2000 from inserting brackets around
the field names in my form's Record Source's select statement????
I created a new database and a couple of forms. I delete the brackets
but Access keeps putting them back in. Any ideas??

Thanks,
James

 

[John Vinson]

I delete the brackets
but Access keeps putting them back in.

Why are you concerned?

If the fieldnames contain blanks or special characters the brackets
are obligatory. If they don't, just let Access put them on. The user
shouldn't be seeing the query anyhow!

 

[JamesJ]

I was more curious than anything.
In my other db (one I've been using for a very long time) there
are no brackets. I personally think it is easier for me
to read the select statements without brackets.

Thanks,
James

 

[John Vinson]

I was more curious than anything.
In my other db (one I've been using for a very long time) there
are no brackets. I personally think it is easier for me
to read the select statements without brackets.

<shrug> Sorry, but you'll just have to [get] [used] [to] [it]... <g>