I have database ready to roll next week but we have run into an issue with one field. I need a Comments field that can be in my table and display on forms and reports.
I originally set it up as a Text field but that is limited to 50 chars. I changed it to a memo field and the Comments show up correctly on the forms but it is displaying special characters on the Reports.
Any suggestions.