I have a table that I was in the process of cleaning up when I got the following errors: "type mismatch in expression" and "microsoft office access can't open the table in Datasheet view." What does this mean, and how can I get rid of these errors? Thanks.
Datasheet View Table error (1 Viewer)
- Thread starter yeppy12
- Start date
DCrake
Remembered
- Local time
- Today, 15:37
- Joined
- Jun 8, 2005
- Messages
- 8,632
Simple Software Solutions
Basically this means that the data in your table does not conform the the type of contents is was expecting. If you changed a field type say from a text to a date field and had spaces in the text field then this will occur. What I would do to resolve this is to create a new query and ring in the offending table, then select one field at a time and view it in datasheet mode. This will tell you which field is causing the error. When found change it to a text field and view it again. Remove any offending entries and change back to the correct type of field. and retry.
CodeMaster:
Basically this means that the data in your table does not conform the the type of contents is was expecting. If you changed a field type say from a text to a date field and had spaces in the text field then this will occur. What I would do to resolve this is to create a new query and ring in the offending table, then select one field at a time and view it in datasheet mode. This will tell you which field is causing the error. When found change it to a text field and view it again. Remove any offending entries and change back to the correct type of field. and retry.
CodeMaster:
