Update query with greek characters

[greeknl via AccessMonster.com]

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

 

[Allen Browne]

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.

 

[greeknl via AccessMonster.com]

I am not quite sure what you mean.
But how would I then convert the complete table to propercase?

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?

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

I am not quite sure what you mean.
But how would I then convert the complete table to propercase?

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?

 

[greeknl via AccessMonster.com]

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

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]

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

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

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?

 

[greeknl via AccessMonster.com]

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?

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]

 

[Allen Browne]

Give it a few hours. Start a new thread of you don't get any takers.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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?

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?

 

[greeknl via AccessMonster.com]

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

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]