Fill conbo box with list of fonts, including font file name

[DevelopV]

In Access 2010, I need to a list box to return all the fonts installed on a computer, including the fonts file name.

How do I do this?

Thanks in advance

 

[Andrzejek]

Did you try looking here?

Have fun.

---- Andy

 

[DevelopV]

Most of the code shows how to get a list of the fonts.
What I am struggling with / cant find, is how to obtain the fonts file name.

Thanks

 

[trevil620]

I was also curious about this so I ran the code that Andrzejek pointed to and it created a document with 340 fonts (Vista), but 32 appear to be duplicate names (just have an @ at front).

Then I looked in folder c:\windows\fonts\ and found 502 items (True Type, Open Type, Raster, etc.)....

Then searched drive for "*.ttf" and found 1,353! However, unless the font was in the '\fonts\ folder, it was not detected by the Word module.

Until you get something better, you could just scan the c:\windows\fonts\ folder and pluck the file names from there.

Maybe that can help?

 

[strongm]

>just have an @ at front

This just means they contain vertical version of the font (a sort of hack, typically for certain Chinese, Japanese and Korean fonts, the idea being that if you want to generate vertical text, you start with the horizontal version of the font and compose your document, then switch to the vertical version for printing)

>a document with 340 fonts ... found 502 items

There are a whole bunch of reasons why some fonts are sometimes hidden from applications (no point listing them if the application can't use them, for example)

>"*.ttf" and found 1,353!

A single font (family), containing various styles, may consist of multiple ttf files. Arial would be good examples, consisting of 9 ttf files