title: MS Access VBA code editor character encoding and copy/paste
body: <p>What is the actual encoding used in Access' VBA editor? I have been searching for a concrete answer for quite a while but with no luck.</p>
  
  <p>I thought it was UTF-8 but I'm not very certain. </p>
  
  <p>My main issue is that when writing a query in VBA I sometimes need to test it in Access' query editor. When copy-pasting however, I lose my native characters (greek in my case) as they turn to gibberish.</p>
  
  <p>I have tried pasting in a text editor and saving it as different encodings but I can never recover the original characters.</p>
  
  <p>Thanks in advance.</p>
  
  <p><strong>Edit</strong></p>
  
  <p>Let me explain this a bit further:</p>
  
  <p>As you can see I can write my greek characters in the VBA editor normally:</p>
  
  <p><img src="https://i.stack.imgur.com/roneM.png" alt="sample in vba editor"></p>
  
  <p>However, copying the first line in Access' query editor, I get the following:</p>
  
  <p><img src="https://i.stack.imgur.com/Oj00R.png" alt="paste in query editor"></p>
  
  <p>Same goes for a simple text editor:</p>
  
  <p><img src="https://i.stack.imgur.com/TREyF.png" alt="text editor"></p>
  
  <p>So I am inclined to think that the problem lies inside the clipboard, due to the encoding used for the greek characters. I guess they are not Unicode, as I indeed have to make the change in the System Locale for non-unicode characters. So how are these characters saved/copied? In what encoding?</p>
  
  <p><strong>Answer</strong></p>
  
  <p>Actually this problem was solved by switching the keyboard input language to greek (EL), when copying the actual test string. </p>
  
  <p>I am still not sure however, as to why that happens. If anyone can provide some insight into this, I would love to hear it.</p>
  
  <p>Thanks again</p>