Difference Between Brackets And No Brackets In Filter?

[VariableZ]

I have a button on Form1 that opens Form2, and there's a little VBA code to filter the form based on in user input on Form1. And it works properly. Was bothers me is that if I go to Advanced Filter/Sort in the newly opened Form2, the fields have brackets around them, whereas if I filter directly on Form2, there are no brackets. I'm probably just being nitpicky, but is there any way to write the VBA filter string so that the fields don't have those brackets? I find them irksome.

[Dal Jeanis]

The brackets are absolutely required when the table names or control names or field names have internal spaces, optional otherwise. You can certainly translate the filter to eliminate the [] using string functions, if you're sure that you don't have internal spaces in any relevant names, and if you're sure that you want to. It would look something like this:

   Me.Filter = Replace (Replace (Me.Filter, "]", ""), "[", "")

Here's a page that lists all the string functions, (and the rest) http://www.techonthenet.com/access/functions/

Please note that there are occasional situations where Access or Jet decides that the brackets are NOT optional, and I can't guarantee you won't run into one of those at any given time.