where can i find the Arial CYR font?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • n8kindt
    New Member
    • Mar 2008
    • 221

    where can i find the Arial CYR font?

    i need to make a report that uses vertical text but, from what i have learned (from searching the forums and the web), the Arial CYR font is the only unicode font that works.

    it costs $20 to download off a website. does anyone know where i can find this for free? or a program that is free that includes the Arial CYR font with the installation file?

    thanks guys.
    --nate
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    Here are some links supplied by Microsoft for you to check out. Let us know if any of them have a free Arial CYR font.





    Comment

    • puppydogbuddy
      Recognized Expert Top Contributor
      • May 2007
      • 1923

      #3
      PS: According to this excerpt from one Russian web site, CYR Fonts are available to install from Windows if you follow these instructions:

      _______________ _______________ _______________ _________

      How do I install Cyrillic fonts on my computer?
      There are many different Cyrillic fonts available on the Internet for download. Below are instructions for installing the standard Windows Cyrillic fonts for Win95/98/NT and for installing the specific two Cyrillic fonts needed for Macintosh users to access the RAO online Russian catalogue.


      Windows95/98/NT:
      You will enable "Multilangu age Support" on your computer by following these steps:

      Go to Start > Settings > Control Panel > Add/Remove Programs.
      Click on "Windows Setup" tab, then click on "Components " tab.
      Find a line named "Multilangu age Support" and click on the check box so that it is selected.
      Click on "Details" button.
      Find the line of 'Cyrillic language support" and click on the check box to select it.
      Click on "OK" and you will return to the previous window.
      Click on "OK" and this will begin the installation.
      NOTE: You may need your Windows95 CDROM for the installation. If you don't have the CD, you will need to go to http://www.microsoft.c om/windows/download/lang.exe and download this file. Save it in a location you can find, go to the file folder location and double click on the file which will self-extract. Now, when the installation asks for the Windows95 CDROM, click on " browse" and go to the location of this folder.
      To be able to type in Cyrillic, you will need to switch between Latin and Cyrillic keyboards by pressing "Left-Alt" and "Shift" at the same time. You should see "En" switch to "Ru" in the system tray on the bottom right edge of the Windows desktop.

      Comment

      • n8kindt
        New Member
        • Mar 2008
        • 221

        #4
        no go. all the links listed still wanted me to buy the arial font (since it is a commercial font) and i think i finally was able to install arial cyr. it was on my computer the whole time but you have to paste the following into your win.sys file...


        Arial Cyr,204=Arial,2 04
        Arial CE,238=Arial,23 8
        Arial Greek,161=Arial ,161
        Arial Tur,162=Arial,1 62
        Arial Baltic,186=Aria l,186

        however, when i did that, and TYPED IN "arial cyr" into the font box in access, it selected it--even thought it was not shown as an option in the drop down combo box. (as a test, i typed in "arial cyr" and access reformatted it to "Arial Cyr" so i know access recognized it) ... even after all of that, it still printed bound text boxes data as #########

        so i dont know what i'm going to do.

        for some background, here is my problem:

        the format of my report looks like this.

        _Label 1_|_Label 2_|_Label 3_
        Control1_|_Cont rol2|_Control3
        Control1_|_Cont rol2|_Control3
        Control1_|_Cont rol2|_Control3

        and i'm trying to change it to look like this:


        _Label 1_|Control1_|_C ontrol1|_Contro l1
        _Label 2_|Control2_|_C ontrol2|_Contro l2
        _Label 3_|Control3_|_C ontrol3|_Contro l3

        the important part is that control1 is at the top of all the columns

        vertical text would have solved the problem (by printing it as a portrait and reading it like a landscape). i've tried printing it using columns, but in order for that to work, the report header should only print once. basically, instead of a header (which displays text at the top of each page), i would need a "lefter" (which would display text in the left margin of each page) for that to work. i'm at a dead end... help anybody????

        Comment

        • puppydogbuddy
          Recognized Expert Top Contributor
          • May 2007
          • 1923

          #5
          There are several ways this can be done. A frequently used method is a function that programatically transposes row and column data using a temp table, which can then be used as the record source for the report. See this link for the function code for this method, and a discussion of another method.

          Comment

          • Scott Price
            Recognized Expert Top Contributor
            • Jul 2007
            • 1384

            #6
            If you want to print vertical text, why don't you use the built-in setting for the text box control?

            Access 2003 (not sure about earlier versions) has a setting in the properties dialog box which accepts a yes/no value for printing vertical text or not.

            Regards,
            Scott

            Comment

            • n8kindt
              New Member
              • Mar 2008
              • 221

              #7
              Originally posted by Scott Price
              If you want to print vertical text, why don't you use the built-in setting for the text box control?

              Access 2003 (not sure about earlier versions) has a setting in the properties dialog box which accepts a yes/no value for printing vertical text or not.

              Regards,
              Scott
              thanks, scott, for your reply. unfortunately, that is my main problem. it works fine in report format but when you print it, all data that are in bound text boxes do not print correctly.

              microsoft knows about it, but does not offer a fix. (http://support.microsoft.com/kb/839779 )
              allen browne's website stated that changing the font to Arial Cyr font (hence, the title of this thread) would be a workaround, but that did not work either.

              anybody have any other suggestions?

              Comment

              • n8kindt
                New Member
                • Mar 2008
                • 221

                #8
                Originally posted by puppydogbuddy
                There are several ways this can be done. A frequently used method is a function that programatically transposes row and column data using a temp table, which can then be used as the record source for the report. See this link for the function code for this method, and a discussion of another method.

                http://support.microsoft.com/kb/202176
                wow, i almost overlooked your reply. this looks very promising. i will give it a shot. thanks for your help!!

                cheers,
                nate

                Comment

                • Scott Price
                  Recognized Expert Top Contributor
                  • Jul 2007
                  • 1384

                  #9
                  I knew that would be too simple a fix!

                  Stephen Lebans does offer a couple of text box controls that rotate the text, one ActiveX and the other not, if I remember correctly, but I think they're for older versions of Access, like 97 and earlier. It might be worth checking out. Table of Contents - Lebans

                  Sorry, but I don't have any other suggestions...

                  Regards,
                  Scott

                  Comment

                  • n8kindt
                    New Member
                    • Mar 2008
                    • 221

                    #10
                    Originally posted by puppydogbuddy
                    There are several ways this can be done. A frequently used method is a function that programatically transposes row and column data using a temp table, which can then be used as the record source for the report. See this link for the function code for this method, and a discussion of another method.

                    http://support.microsoft.com/kb/202176
                    IT WORKED! thank you so much!!! VERY appreciated

                    cheers,
                    nate

                    Comment

                    • n8kindt
                      New Member
                      • Mar 2008
                      • 221

                      #11
                      Originally posted by Scott Price
                      I knew that would be too simple a fix!

                      Stephen Lebans does offer a couple of text box controls that rotate the text, one ActiveX and the other not, if I remember correctly, but I think they're for older versions of Access, like 97 and earlier. It might be worth checking out. Table of Contents - Lebans

                      Sorry, but I don't have any other suggestions...

                      Regards,
                      Scott
                      thanks, scott for your help. i want to thank you again for your input about 2 weeks ago when you provided a link to allen browne's website concerning self joins on the thread i posted titled "pyramid commission." i was dead in the water before you made that suggestion.

                      cheers, pal..
                      --nate

                      Comment

                      • Scott Price
                        Recognized Expert Top Contributor
                        • Jul 2007
                        • 1384

                        #12
                        :-) NP Nate!

                        Glad you found something that works!

                        Regards,
                        Scott

                        Comment

                        • n8kindt
                          New Member
                          • Mar 2008
                          • 221

                          #13
                          Originally posted by n8kindt
                          IT WORKED! thank you so much!!! VERY appreciated

                          cheers,
                          nate
                          lol ok.... let me amend that post:

                          "IT kinda WORKED!"

                          grrrr... there a new group of problems now and i'm not sure if they can be solved.

                          now that the values are grouped together in the same column it creates the following problems:

                          1) i will have to constantly perform maintenance on the report because the table i'm creating will change in size every single month. for instance, it can go anywhere from 1 column to 20 columns. i will manually have to add or remove fields to the report each month. otherwise, i will get an #Error msg or data will be omitted. on top of that, the first column in the report is text (anywhere from 16-20 chars long) and the rest are 8 digit numbers (currency). i will constantly have to resize the width of the fields b/c all the columns are automatically sized to fit the 16-20chars long text.

                          2) (and probably most importantly) i have no way to change numbers into currency. i don't believe there is a way to do this through vba since i have both date, text, and string values within this column. changing one would theoretically change all using the code i was provided.

                          here's a picture example of how my report looks now


                          also, now you can see why i need the report formatted this way. the dates need to be on top and the column names would be too wide to fit on a single sheet of paper.

                          Comment

                          • Scott Price
                            Recognized Expert Top Contributor
                            • Jul 2007
                            • 1384

                            #14
                            How much coding do you want to do? :-)

                            A potential solution would involve setting all your control's visible property to False, then using the Me.Print method in the reports' detail section to print the text directly to the underlying report. I have used this myself, and it is quite flexible (haven't figured out how to change the text to vertical, though, but haven't tried either :-).

                            Basically you need to initialize a set of variables that hold the X and Y coordinates for your columns, as well as the font that you want to print in. Then you fire the .Print command after updating the variables to reflect empty controls, width of text, height of text, desired font/properties, etc. Let me know if you are interested, and I can post a sample code section. Let me warn you, though, that this solution would probably require roughly a couple hundred lines of code (I have upwards of 400 for the report I use this on) thus it isn't the most likely solution if you have little interest in writing code :-)

                            Regards,
                            Scott

                            Comment

                            • n8kindt
                              New Member
                              • Mar 2008
                              • 221

                              #15
                              Originally posted by Scott Price
                              How much coding do you want to do? :-)

                              A potential solution would involve setting all your control's visible property to False, then using the Me.Print method in the reports' detail section to print the text directly to the underlying report. I have used this myself, and it is quite flexible (haven't figured out how to change the text to vertical, though, but haven't tried either :-).

                              Basically you need to initialize a set of variables that hold the X and Y coordinates for your columns, as well as the font that you want to print in. Then you fire the .Print command after updating the variables to reflect empty controls, width of text, height of text, desired font/properties, etc. Let me know if you are interested, and I can post a sample code section. Let me warn you, though, that this solution would probably require roughly a couple hundred lines of code (I have upwards of 400 for the report I use this on) thus it isn't the most likely solution if you have little interest in writing code :-)

                              Regards,
                              Scott
                              let me speak with the person who will be receiving the final report first. i would be willing to do it. however, i'm not sure if this person would be interested in paying me to do it lol. i never thought this report would ever get so involved! i will back to you in the next couple days. once again, thanks for your help.

                              --nate

                              Comment

                              Working...