<div>
<div class="content wysiwyg-content">
On a form I have a click event with this code:<br />
<br />
&nbsp; &nbsp; Me.Filter = &quot;[Sale Price] = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Me.txtSalePrice &amp;&nbsp;Chr(34)<br />
&nbsp; &nbsp; Me.FilterOn = True<br />
<br />
But I get a data type mismatch error. &nbsp;The field is a Currence formatted field so I'm sure the syntax of my code is wrong. &nbsp;It works fine if the field is a text field.<br />
<br />
Then,<br />
<br />
I have the same issue with a date field... here's my code for that but I get a data type mismatch error there too...<br />
<br />
&nbsp; &nbsp; Me.Filter = &quot;[Sale Date] = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Me.txtSaleDate &amp;&nbsp;Chr(34)<br />
&nbsp; &nbsp; Me.FilterOn = True<br />
<br />
???
</div>
</div>


On a form I have a click event with this code:

    Me.Filter = "[Sale Price] = " & Chr(34) & Me.txtSalePrice & Chr(34)
    Me.FilterOn = True

But I get a data type mismatch error.  The field is a Currence formatted field so I'm sure the syntax of my code is wrong.  It works fine if the field is a text field.

Then,

I have the same issue with a date field... here's my code for that but I get a data type mismatch error there too...

    Me.Filter = "[Sale Date] = " & Chr(34) & Me.txtSaleDate & Chr(34)
    Me.FilterOn = True

???

Filter syntax issue

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.