AccuZIP Inc Postal SoftwareAccuZIP6 Standard EditionAccuZIP6 Business EditionAccuZIP6 Professional EditonMore SolutionsAccuZIP6 Customer TestimonialsContact AccuZIP Inc at 800-233-0555
Technote: W610
Title: Error: Data Type Mismatch
Edited: July 1, 2008

When you attempt to validate your records, optimize your database or presort your database, you might encounter an error with the message: Data Type Mismatch. This error means that one of your fields, probably the ZIP field is a Numeric type instead of Character as it should be.

  1. To change the field type, follow these instructions:
  2. From the Edit menu, choose Fields.
  3. Locate the field named ZIP and change the Type to Character.
  4. Make sure the width of ZIP is 10 characters wide.
  5. Click OK, then click Yes to save changes.
  6. Pull down the Special menu to Optimize Database.
  7. Click Optimize.
Other fields that commonly have an incorrect type
Field name Type
Barcode Character
CRRT Character
CNT_ Numeric
LOT_ Character
ASCDESC_ Character
DP_ Numeric

Note: For a list of all AccuZIP6 fields and their types, pull down the Help menu to Contents. That will open the Table of Contents in the AccuZIP6 User's Guide. Click on the Appendix book, then click on the AccuZIP6 Field Descriptions topic.