Font List in font style (1 Viewer)

[Martin Beney]

Hi, Has anyone found a way to create a list of fonts in their corrseponding font.

The list is obviously very easy. But a list box or even a treeview control does not allow each item to have a different font! Simulating a list box with text boxes and a scroll bar is a huge job and I want to be lazy and use a prebuilt solution!

Cheers

 

[Minty]

Try displaying a report in a form, that would possibly work as you can change the font per detail line in the format event?

 

[arnelgp]

excel has one,

Application.Dialogs(xlDialogFont).Show

Edit:
also Mr.Kallal has some beautiful VBA here:

Open the Font Picker dialog box in ACCESS 365 and Windows 10 - Microsoft Q&A

Recently I have been all over the internet attempting to find VBA code that will open the Font Dialog in ACCESS. There have been many solutions but unfortunately none have worked and one uses the CopyMemory function which crashes my ACCESS application…

learn.microsoft.com

 

[Martin Beney]

Thanks for the suggestions.

The opening the font picker will do perfectly.