Type Mismatch Error Message

When I attempt to map a FP2003 form field to a SQL database column I receive
the following error message:

"The type of field "additional_notes" does not match the type of column
"additional notes" in the database. Modify the field mapping or change the
validation settings on the form field." Additional notes is just one of many
fields for which I receive the error. Some are text, some numbers.
Originally I had all the fields set to No Constraints.

I've tried changing the entry type from No Constraints to Text, as well as
making the field data length required or not without success.

Thanks in advance,

Ed
.

Relevant Pages

  • Re: Type Mismatch Error Message
    ... > When I attempt to map a FP2003 form field to a SQL database column I ... > the following error message: ... > Originally I had all the fields set to No Constraints. ...
    (microsoft.public.frontpage.programming)
  • Re: Autotext FormField
    ... Not sure about the error message, ... using the same AutoText entry. ... This message is posted to a newsgroup. ... > When I insert an autotext with a form field I get the FORMTEXT ...
    (microsoft.public.word.application.errors)
  • Re: Need to change Validation Error Messages
    ... > I am trying to validate a form field and have> put the value of the field in the properties, but when> testing and I test it incorrectly, the error message is ... How can this show just an alert that> says "Incorrect Password"? ...
    (microsoft.public.frontpage.programming)
  • Re: Normal.dot Issue
    ... All I'm doing is utilizing the form field command in Word. ... error message that the global document has changed, and would I like to save ... > Microsoft Office MVP ... >> Still getting message that the normal.dot template has changed, ...
    (microsoft.public.office.misc)
  • Re: Normal.dot Issue
    ... Remove "NoSpam4Me" to obtain a valid email address: ... > All I'm doing is utilizing the form field command in Word. ... > error message that the global document has changed, ... > specific to my machine because I have tried it on numerous machines ...
    (microsoft.public.office.misc)