Data type conversion error

  • Thread starter Thread starter Susan D
  • Start date Start date
S

Susan D

when I try to create labels using the report wizard, I
get a "Data type conversion error." Can anyone help me
determine the problem and how to resolve it?

Thanks!
 
Susan D said:
when I try to create labels using the report wizard, I
get a "Data type conversion error." Can anyone help me
determine the problem and how to resolve it?
Click to expand...

The report wizard uses the Trim() function to ensure that there aren't any
leading or trailing spaces. If one of the fields is numeric, Trim() will
cause a type mismatch. Just Remove the Trim() function and the error should
go away.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
How do I remove the Trim() function?

I'm using a select query as the object data source and
all the fields are text fields. I also get the data type
conversion error when I try to link to a table. I was
able to export the Access 2002 table into Access 97 and
the label wizard worked without errors.
 
Back
Top