August 18th, 2013, 07:33 PM
Join Date: Apr 2013
Time spent in forums: 19 m 13 sec
Reputation Power: 0
Problems with turkish charachters in VBA coding
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
Ğ ğ ı İ Ş ş
will not display in the vba editor and I have to resort to using
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
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 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.