type mismatch in expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 23 Jun 2006 00:34 GMT

I'm an Access newbie. I created a form and some tables and entered 400
records. I went back in and added several rows to a table and now when I try
to go into my form to add more records I get the error "type mismatch in
expression". I have no idea what to do. I'm not a coder I'm just a user
entering simple data.

Can anyone tell me how to fix my problem?

Thanks!!!

Reply to this Message

Arvin Meyer [MVP] - 23 Jun 2006 01:18 GMT

You have the wrong data in one of the fields. For instance you are trying to
add text into a numeric field. You might check your phone and zip code
fields first. Make sure they are the text datatype in the table.

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

> I'm an Access newbie. I created a form and some tables and entered 400
> records. I went back in and added several rows to a table and now when I
[quoted text clipped - 6 lines]
>
> Thanks!!!

Reply to this Message

Sarah - 23 Jun 2006 01:29 GMT

alvin,

thanks for the quick response. not sure where to make the change - i
checked the table and the fields are listed as number for the id and text for
the person's name.

> I'm an Access newbie. I created a form and some tables and entered 400
> records. I went back in and added several rows to a table and now when I try
[quoted text clipped - 5 lines]
>
> Thanks!!!

Reply to this Message

Arvin Meyer [MVP] - 23 Jun 2006 01:41 GMT

That is probably correct. Do you have a phone number field or a zip code
field in your table? You would make the change in the table's design view.
Make sure you have a backup copy of yopur file before attempting any
changes.

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

> alvin,
>
[quoted text clipped - 13 lines]
>>
>> Thanks!!!

Reply to this Message