Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    code with cyrilic fails (Access 2000)

    Help with the cyrillic options - Access 2000

    I use the Cyrillic alphabete and at the end of my invoice, when i use the function called NumWord to convert the numbers into words, i receive with my computer unreadable texts. I think i must change something into the Regional settings, but i do not know how. The Regional settings are set to Cyrillic anyway. In all the other cases i use the font ArialCyr and ir works,
    but only with this function it doesnt work, although the font of my control is with Arial Cyr.
    Also, when i types the code in the Modules section, i casn type in cyrillic, but if i want to copy the text and paste again, i receive
    unreadable text. Here is the text i receiv when copied:


    Static Function NumWord(ByVal AmountPassed As Currency) As String
    '** Convert a number to words for filling in the Amount of a check
    '** Example: NumWord(120.45) returns ONE HUNDRED TWENTY AND 45/100
    '** Can handle numbers from 0 to $999,999.99. Created by Alan Simpson

    '** The array below, and other variables, are dimensioned
    '** in the Declarations section.
    If Not EngNum(1) = "

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: code with cyrilic fails (Access 2000)

    Working with colleagues who work primarily in Cyrillic, I can confirm that what you are seeing is the attempt of a non-Cyrillic codeset to render Cyrillic characters. This happens in Outlook which attempts to use Tahoma for all purposes. It is conceivable that, for some reason, Access is attempting to use a non-Cyrillic fixed width font - although at present I cannot see why that should be the case. Wish I could add more. HTH
    Gre

  3. #3
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: code with cyrilic fails (Access 2000)

    You are correct, VBE uses ASCII characters only, not extended character set.
    To force Access to display cyrillic letters correctly, the code must be like this:

    EngNum(1) =ChrW(1086) & ChrW(1076) & ChrW(1080) & ChrW(1085)
    EngNum(2) = ChrW(1076) & ChrW(1074) & ChrW(1072)
    EngNum(3) = ChrW(1090) & ChrW(1088) & ChrW(1080)

    etc.

    (I used Office XP on WinXP to generate this characters, but I believe Office 2000 uses the same characters.)

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: code with cyrilic fails (Access 2000)

    Have you set the VBE option to use a Cyrillic font?

    StuartR
    Attached Images Attached Images

  5. #5
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: code with cyrilic fails (Access 2000)

    Disregard my previous post, please.

    Today I open your post in IE 6 browser with Encoding auto-select option, and can see all characters properly. The problem with your code is: wrong CodePage used. (See Cyrillic Character Sets for details.)

    To fix the problem, try Character Set Converter or make Windows recognize Cyrillic fonts (see http://www.gwu.edu/~slavic/cyrilize.htm for step-by-step instructions.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •