Parameters Tab, Properties Window
Specifies options for marking parameters in the query.
To include a parameter in a query, you must mark the parameter using special characters so that the Query Designer does not mistake your parameter name for text data. For example, if you specify square brackets ( [ and ] ) as parameter markers, you can enter a parameter by specifying a search expression such as the following:
= [last_name]When you run the query, the Query Designer prompts you for a value, and then substitutes the value you provide for the parameter last_name.
For more information about using parameters in queries, see Parameter Queries.
Options
Prefix characters
Specifies the character or characters that mark the beginning of a parameter.
Suffix characters
Specifies the character or characters that mark the end of a parameter.
Escape character
Specifies an escape character that is used to indicate that a parameter marker character in a name is meant literally. For example, if you specify "%" as a parameter marker, you would not normally be able to include that character in a parameter name such as "% complete." However, you can specify "\" as an escape character, and then use the following string as the parameter name:
%\% complete%