I have some reports which need to be created in either english or turkish.
the data displayed is not the problem.
I change the field labels to read in turkish or english depending on which language is required.
however some turkish characters
specifically
Ğ ğ ı İ Ş ş
will not display in the vba editor and I have to resort to using
ChrW(286)
ChrW(287)
ChrW(305)
ChrW(304)
ChrW(350)
ChrW(351)
in the code to change the labels
obviously this can be quite time consuming especially when I have large chunks of text to check and convert.
I was thinking that I could create a form where I could type in the text and it would be read and checked for those characters and they could be replaced with the correct codes and then I could paste that directly into the VBA code.
something along these lines
KİRA SÖZLEŞMESİ
which would return
"K" & ChrW(304) & "RA SÖZLE" & ChrW(350) & "MES" & ChrW(304)
I have a table with the special codes in, and I imagine that I need to do some form of lookup and replace from there, but it is the reading the original text and checking for characters that I have problems doing.
Any help would be greatly appreciated, otherwise I have endless hours of manually going through text and the inherent problems that will cause.
I should reiterate in Access forms/reports etc the characters display ok, it is only in VBA there is a problem.
the data displayed is not the problem.
I change the field labels to read in turkish or english depending on which language is required.
however some turkish characters
specifically
Ğ ğ ı İ Ş ş
will not display in the vba editor and I have to resort to using
ChrW(286)
ChrW(287)
ChrW(305)
ChrW(304)
ChrW(350)
ChrW(351)
in the code to change the labels
obviously this can be quite time consuming especially when I have large chunks of text to check and convert.
I was thinking that I could create a form where I could type in the text and it would be read and checked for those characters and they could be replaced with the correct codes and then I could paste that directly into the VBA code.
something along these lines
KİRA SÖZLEŞMESİ
which would return
"K" & ChrW(304) & "RA SÖZLE" & ChrW(350) & "MES" & ChrW(304)
I have a table with the special codes in, and I imagine that I need to do some form of lookup and replace from there, but it is the reading the original text and checking for characters that I have problems doing.
Any help would be greatly appreciated, otherwise I have endless hours of manually going through text and the inherent problems that will cause.
I should reiterate in Access forms/reports etc the characters display ok, it is only in VBA there is a problem.
