Bracketed Field Names

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

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
 
I delete the brackets
but Access keeps putting them back in.
Click to expand...

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!
 
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
 
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.
Click to expand...

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