Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Elise - 17 Oct 2005 16:26 GMT
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?
Signature

Elise King-Lynch

John Vinson - 17 Oct 2005 17:57 GMT
>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 - 17 Oct 2005 19:25 GMT
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.

Signature

Elise King-Lynch

> >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
[quoted text clipped - 12 lines]
>
>                   John W. Vinson[MVP]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.