search

x-ware-ltd / access-scc-addin

Microsoft Access SCC Addin
Apache License 2.0
2 stars 4 forks source link

Work around bug in MSAccess #51

Open gilbertbw opened 4 years ago

gilbertbw commented 4 years ago

Migrated from internal Tasklist ref 2682:

It appears that extended characters are not dealt with correctly in the SaveAsText/LoadFromText functions for forms:

To reproduce:

  1. Create a new DB and add a new form
  2. Add a button, remove the graphic and change the caption to 'e', close/save form
  3. Use SaveAsText from debug window: Application.SaveAsText acForm, "Form1", "C:\Form1A.acm"
  4. Reopen form in design view
  5. In MS Word select 'Insert Symbol', under Symbols use 'subset Basic Greek'. Find Epsilon () and cut past to the caption in the Button (alternatively cut and paste the character from the Epsilon.txt file in Doc Count)
  6. Close/Save Form and SaveAsText: Application.SaveAsText acForm, "Form1", "C:\Form1B.acm"

Trying to LoadFromText the second file will casue Access to Crash! Also note the diff on the file is the checksum.