@ automatically creates an InputParameters

[mileo]

I have a made a DIY QBF form that works fine, some of the items search for contain wildcard characters like % with I deal with by a small bit code that puts [ ] around the characters, then I build the SQl String for the record source of the form.

If the @ symbol is being searched for Access automatically thinks it should be an input parameter and puts the value into forms InputParmeter property. This I not what I want, can I turn this feature off?

 

[mileo]

To get round this issue I know replace the @ in my sql string with CHAR(64), its a bit messy but works for me.


if InStr(1, strSQL, "Like N'@%") > 1 Then
strSQL = Replace(strSQL, "Like N'@%", "LIKE CHAR(64) + N'%")
Else
strSQL = Replace(strSQL, "@", "'+ CHAR(64)+ N'")
End If