I run VBScript from Outlook to populate a text field. I'm grabbing a value from a SQL table:
ctls("lblPartDesc").Caption = "Part Desc: " & rst.Fields("description")
When the field in SQL is a text field, it gives a data type mismatch error. But when it is a varchar type it's fine. I've tried cstr() and it still doesn't work. Also, I'm not allow to change the field in the sql table to varchar because it's not my database.