query save problem

[Guest]

I'm running an UPDATE query, however, when the filed name has a space in
front of a bracket, access deletes the space when the query is saved.

For example, when I have:
SET [Palletizing (Robots)] = Nz([Palletizing (Robots)],0),

After saving query, when I open it again, it becomes:
SET [Palletizing(Robots)] = Nz([Palletizing (Robots)],0),

The space between Palletizing and (Robots) is deleted. If I run the query
without correcting it every time, a message box pops up asking about
parameter value, because the field name has been changed.

I've also noticed that it doesn't happen on all of the fields with brackets
in their names, but there's at least one of them in each query I have that
has the problem.

Is this a program bug? Is there any way to fix it?

Thanks,

 

[Jeff L]

It's usually not a good idea to use special characters in field or
variable names. Stick to letters and numbers.