Re: Type Mismatch Error Message

What is the data type of the column in your database? What is the data type
of the column in your Database Results Wizard?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

"Ed" <Ed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B1CBED2-F599-46B3-AE7F-ED44E0556CD1@xxxxxxxxxxxxxxxx
> 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: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: runtime error with Mask edit control
    ... DateOfBirth property is a string. ... If no value is entered into the Property, the database stores a null. ... > its data type (one would assume the same as the property, ...
    (microsoft.public.vb.controls)
  • Re: Type Mismatch Error Message
    ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
    (microsoft.public.frontpage.programming)
  • Re: Search for columns in tables that are a specific data type?
    ... It may be more info than you want, but you can use the Database Documenter ... was the AutoNumber data type; it did get migrated as an Integer, ... I know how to do this in SQL but can't seem to find ...
    (microsoft.public.access.queries)
  • RE: function doesnt return value - SOMETIMES!
    ... It seems the calling stack has some issues. ... If not, I suggest that you create a new database, and import the ... |> thing I can see is that you are declaring 3 of your numerical values as ... |> when it does work correctly that would be because this data type is ...
    (microsoft.public.access.modulesdaovba)
Loading