If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update query with greek characters
I want to do an update query on a table I imported to change all records to
propercase. So far no problems. In my table I have also a lot of greek names (in the greek alphabet) and when I run the query all greek letters are replaced by questionmarks. As this is a long table I want to avoid doing it all by hand. Can someone help me? Thanks -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Update query with greek characters
Try creating a form bound to this table.
In Form Design view, select the field that should contain the Greek characters, and set the Font to a Greek font. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "greeknl via AccessMonster.com" u30909@uwe wrote in message news:7165e1da696c5@uwe... I want to do an update query on a table I imported to change all records to propercase. So far no problems. In my table I have also a lot of greek names (in the greek alphabet) and when I run the query all greek letters are replaced by questionmarks. As this is a long table I want to avoid doing it all by hand. Can someone help me? |
#3
|
|||
|
|||
Update query with greek characters
I am not quite sure what you mean.
But how would I then convert the complete table to propercase? Allen Browne wrote: Try creating a form bound to this table. In Form Design view, select the field that should contain the Greek characters, and set the Font to a Greek font. I want to do an update query on a table I imported to change all records to propercase. So far no problems. [quoted text clipped - 3 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200704/1 |
#4
|
|||
|
|||
Update query with greek characters
I don't understand that reply.
I am not aware of any connection between choosing the correct font so the text is displayed as characters of the Greek alphabet instead of question marks, and converting the case of the text. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "greeknl via AccessMonster.com" u30909@uwe wrote in message news:716d55928e87a@uwe... I am not quite sure what you mean. But how would I then convert the complete table to propercase? Allen Browne wrote: Try creating a form bound to this table. In Form Design view, select the field that should contain the Greek characters, and set the Font to a Greek font. I want to do an update query on a table I imported to change all records to propercase. So far no problems. [quoted text clipped - 3 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? |
#5
|
|||
|
|||
Update query with greek characters
Sorry if I was vague
But when I convert the table to ProperCase, the fileds containing greek words are converted to questionmarks. My database works fine with the greek characters, except when performing the mentioned task. A real pain... Thanks anyway for all the prompt replies Allen Browne wrote: I don't understand that reply. I am not aware of any connection between choosing the correct font so the text is displayed as characters of the Greek alphabet instead of question marks, and converting the case of the text. I am not quite sure what you mean. But how would I then convert the complete table to propercase? [quoted text clipped - 9 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? -- Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
Update query with greek characters
Ah, I think I see.
Using StrConv() with the vbProperCase argument on a field with Greek characters did not convert a lower case alpha into an upper case alpha as you expected. Instead it converted to an unreadable/undisplayable character. That could certainly be the case if the Unicode font used a non-ASCII character to display the foreign character. Clearly using StrConv() is not appropriate for this case. Perhaps someone who works with other fonts and languages could suggest an alternative approach. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "greeknl via AccessMonster.com" u30909@uwe wrote in message news:717715e09e9a0@uwe... Sorry if I was vague But when I convert the table to ProperCase, the fileds containing greek words are converted to questionmarks. My database works fine with the greek characters, except when performing the mentioned task. A real pain... Thanks anyway for all the prompt replies Allen Browne wrote: I don't understand that reply. I am not aware of any connection between choosing the correct font so the text is displayed as characters of the Greek alphabet instead of question marks, and converting the case of the text. I am not quite sure what you mean. But how would I then convert the complete table to propercase? [quoted text clipped - 9 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? |
#7
|
|||
|
|||
Update query with greek characters
Thank you for this answer.
Should I make a new thread using the info you gave me in order to get an answer or will this post be seen? Allen Browne wrote: Ah, I think I see. Using StrConv() with the vbProperCase argument on a field with Greek characters did not convert a lower case alpha into an upper case alpha as you expected. Instead it converted to an unreadable/undisplayable character. That could certainly be the case if the Unicode font used a non-ASCII character to display the foreign character. Clearly using StrConv() is not appropriate for this case. Perhaps someone who works with other fonts and languages could suggest an alternative approach. Sorry if I was vague But when I convert the table to ProperCase, the fileds containing greek [quoted text clipped - 17 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? -- Message posted via http://www.accessmonster.com |
#8
|
|||
|
|||
Update query with greek characters
Give it a few hours. Start a new thread of you don't get any takers.
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "greeknl via AccessMonster.com" u30909@uwe wrote in message news:7177daeba20bc@uwe... Thank you for this answer. Should I make a new thread using the info you gave me in order to get an answer or will this post be seen? Allen Browne wrote: Ah, I think I see. Using StrConv() with the vbProperCase argument on a field with Greek characters did not convert a lower case alpha into an upper case alpha as you expected. Instead it converted to an unreadable/undisplayable character. That could certainly be the case if the Unicode font used a non-ASCII character to display the foreign character. Clearly using StrConv() is not appropriate for this case. Perhaps someone who works with other fonts and languages could suggest an alternative approach. Sorry if I was vague But when I convert the table to ProperCase, the fileds containing greek [quoted text clipped - 17 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? |
#9
|
|||
|
|||
Update query with greek characters
I came accross the function Ucase() which changes strings to Uppercase.
I hope this will work also in the query because in VBA it worked fine. Again thanks for all the help Allen Browne wrote: Give it a few hours. Start a new thread of you don't get any takers. Thank you for this answer. Should I make a new thread using the info you gave me in order to get an [quoted text clipped - 19 lines] As this is a long table I want to avoid doing it all by hand. Can someone help me? -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|