VBA string variable can not handle strange characters, Long text field (Memo field)
A VBA string containing a long text variable should be able to be handled in VBA without reading the variable content as part of the string.
For now Access vba apparently reads the variable content, and a long variable (string) contains odd characters it either gives an error or populates the variable text truncated.
The only way today handle such long text strings with odd characters is unfortunately enforcing use of ADO 3.6 Library and using late binding and record sets, then access vba do not read the variable content as part of the string.
Suggestions related to VBA editor should be posted in the Office Developers User voice site here – https://officespdev.uservoice.com/
Closing this suggestion so you can have your votes back.