MS Access VBA code editor character encoding and copy/paste -

what actual encoding used in access' vba editor? have been searching concrete answer quite while no luck.

i thought utf-8 i'm not certain.

my main issue when writing query in vba need test in access' query editor. when copy-pasting however, lose native characters (greek in case) turn gibberish.

i have tried pasting in text editor , saving different encodings can never recover original characters.

thanks in advance.

edit

let me explain bit further:

as can see can write greek characters in vba editor normally:

however, copying first line in access' query editor, following:

same goes simple text editor:

so inclined think problem lies inside clipboard, due encoding used greek characters. guess not unicode, indeed have make change in system locale non-unicode characters. how these characters saved/copied? in encoding?

answer

actually problem solved switching keyboard input language greek (el), when copying actual test string.

i still not sure however, why happens. if can provide insight this, love hear it.

thanks again

the vba editor not support unicode characters, either input or display. instead, uses older windows technology called "code pages" provide support non-ascii characters.

so, character encoding in vba editor corresponds code page used windows system locale specified in "regional , language options" control panel. example, system locale set "greek (greece)"

i can enter greek characters vba code

however, if switch windows system locale "english (united states)"

and re-open vba project, greek characters have changed corresponding characters in new code page