where can i find the Arial CYR font?

[n8kindt]

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]

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.

http://www.microsoft.com/typography/links/links.aspx?type=foundries&part=1

http://www.microsoft.com/typography/fonts/default.aspx

http://www.microsoft.com/typography/links/FontPortal.aspx?PID=9

[puppydogbuddy]

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.

[n8kindt]

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????

[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

[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

[n8kindt]

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?

[n8kindt]

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

[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

[n8kindt]

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

[n8kindt]

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

[Scott Price]

:-) NP Nate!

Glad you found something that works!

Regards,
Scott

[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.

[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

[n8kindt]

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