type mismatch in expression

[Guest]

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!!!

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

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.

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access