I am working on a form in Access for my employees to use to create weekly task reports.
There is a field for "Tasks." Once this is filled out, the user clicks on a button and the task is added to two tables and I am able to create a report.
I am running into the problem that the user receives an error message if an apostrophe is used. I have seen code that allows a particular string to have an apostrophe, but I don't know what to do if the apostrophe could be entered at any time in different descriptions of the tasks.
How do I fix this?