Syntax Error using Filter-by-Form

J

Jennifer

When I try to filter records using Filter-by-Form button I
get a syntax error when the fieldname I want to search for
contains a bracket - Is there any way I can solve this or
is it simply a matter of not using brackets in my field
names?
 
J

John Spencer (MVP)

In my opinion you should NEVER use any special characters in field and table
names. It only leads to problems. My personal rule is to use only letters,
numbers, and underscores if I can.

Using a bracket means trouble in Access since Access uses brackets to handle
field and table names with special characters. You might, emphasize might, be
able to get away with a bracket in a field name or a tablename, but you will
always have to refer to the field with brackets around the entire name.
Something like:

[Table Name].[Name with [ in it]

I'm not sure that will even work, because I've never tried to do something like that.
 
Top