Syntax error on an input mask that was created by the wizard

[Elise]

I created a form with a field for the telephone number. The field is defined
as a text field with an input mask of \(999")"999-9999::- which I created
using the wizard. I also defined an input mask for the field in the form
using the wizard. Now when I open the form I get the message:
Syntax error (missing operator)in query expression '(999) 999-9999::_'

I've done this with a form and its sub form. I ignore the message and the
main form opens with the field displayed as I asked but the sub form won't
open at all.
I tried deleting the input mask from the form ( the mask didn't even show in
the properties of the field in the sub form) and I still get the syntax
error. The form is built on a query but I can't see where that would make
any difference.

Any suggestions?

 

[John Vinson]

I created a form with a field for the telephone number. The field is defined
as a text field with an input mask of \(999")"999-9999::- which I created
using the wizard. I also defined an input mask for the field in the form
using the wizard. Now when I open the form I get the message:
Syntax error (missing operator)in query expression '(999) 999-9999::_'

Doublecheck: are you certain that you haven't accidentally put this
text into the control's Default Value property instead of its input
mask?

If that's not it, please open the form in design view; view its
Properties; find the Recordsource property on the data tab and open it
as a query. Somehow the mask is being used as a query criterion. Post
the SQL text here if it's not obvious.

John W. Vinson[MVP]

 

[Elise]

Thanks so much. Somehow the mask ended up under filter (below record
source). I have no idea how that happened. I guess the message I got on the
main form was due to the error in the sub form.

Thanks again.