kaina280 Posted January 8, 2022 Report Share Posted January 8, 2022 I am using some of the user fields to track album name and artist on compact discs. Some of the names have special characters in them. When I try to update a record where one of the fields contains a single quote, I get the above error. admin 1 Quote Link to comment Share on other sites More sharing options...
admin Posted January 10, 2022 Report Share Posted January 10, 2022 Hi, can you reply with some of the special characters that you are using. We will take a look. Quote Link to comment Share on other sites More sharing options...
kaina280 Posted January 11, 2022 Author Report Share Posted January 11, 2022 The single quote seems to trip it up. I'm guessing that the single quote doesn't get escaped. Fields that contain an & work but cause the data to display incorrectly in the search for text results. For example, A&M displays as AM with the M underscored. dealio 1 Quote Link to comment Share on other sites More sharing options...
dealio Posted February 12, 2022 Report Share Posted February 12, 2022 MS Access is the database used for HomeManage. As someone who use to write code in MS Access, I'm aware that the single quote can cause issues when the app tries to save it to the database if it is not treated properly. There is nothing you can do, It's a bug. The same is true for the & -- it is a special character that has meaning on MS Access forms and it cause the exact results you found -- to put an underscore under the character following it. These characters have to be treated specially within the program in order to get saved properly in the database. They are bugs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.