Determining which fonts are installed

[u0107]

Hello,

This question has been asked on the Google groups also but I have not found a satisfactory answer to it - especially in Access -2000.

Is there some way in which I can determine the names of the fonts that are installed on a computer and populate it inside a combo box for the user to choose? (Once again - looking for a solution in Access 2K)

Any working / proven code which anyone is willing to share?

Thanks in advance.

Cheers!

Uttam

 

[Monkey]

Don't know if it works though, but chech www.allapi.net.
They have a program which contains a few hundred api calls. I think one of them will help you out.

There has been some postings in the excel forum before. Don't know where but it has been recently

Hope this works out for you

Greeting monkey

 

[Iridium]

Sorry - no access solution but have xl and word if thats any use?

http://www.erlandsendata.no/english/vba/misc/fontlistxl.php
http://www.erlandsendata.no/english/vba/misc/fontlistwd.php

 

[u0107]

Hello,

I discovered that there IS Code available in the Access 2000 Developer's Handbook - specifically # 17.8.

If it is proper to do so, would someone share the code with me?

Thanks in advance

Uttam

 

[u0107]

Hello,

I did the most logical thing - I went out and bought the book and copied the code from it. Two points:

1) I bought the book on the net at a highly discounted price - nearly 38% discount. (write to me by email in case you wish to know where)

2) As the book does allow you to use the code freely so long as the source is acknowledged, I used it in my application. There are certain precautions which one needs to exercise in the use of the code:

a) The code is only for displaying the fonts installed. If you want to involve a table of any kind where a chosen font is to be written into the table, then you have to write your own code additionally.

b) While copying the code, you need to change many of the Functions from Private to Public.

Hope this helps.

Cheers!

Uttam