Question Embedding fonts in Access DB

[alvingenius]

Hello
Good day to all,

i'm using a custom fonts from windows in Forms and Reports and i wanna embed them to access front end

instead of making a package and attach fonts files , i want it to go through access it self, like creating a table with fonts and attach fonts on the table and with a code to copy this fonts to system fonts

and i saw this post in UtterAccess that have my same question

https://www.utteraccess.com/forum/index.php?showtopic=2050914&view=findpost&p=2697549

and i'm quoting this post

You can do what you ask. I do it by storing the font(s) in a table as a BLOB. This makes deployment very simple

How it works:

When the Application opens it runs VBA code to save the font from the table to the hard drive and registers it in Windows so it can be used.

When the application closes it removes the font.

I have created an example that prints barcodes. It stores the font in the database. It has the code you need to do what you desire.

See the example Print Barcodes on an Access report

I have run this with Access 2003/2007/2010/2013/2016 (full and runtime) on Windows 7/8.x/10/2008/2012

but i don't know how to customize the code based on my custom fonts

 

[isladogs]

Why not ask the question at UA? Perhaps the original author will respond.

 

[theDBguy]

Hi. Not sure you would need to customize the code. It says to just store your font in the table to use it.

 

[Pat Hartman]

Just FYI, make sure that the fonts are not proprietary and that you don't need to pay for copies for each PC.

 

[alvingenius]

Hi. Not sure you would need to customize the code. It says to just store your font in the table to use it.

how to do it ? storing the font(s) in a table as a BLOB

 

[isladogs]

For info, I think Alvin may now have found code by Boyd Trimmell to do this at UA https://www.access-programmers.co.uk/forums/showthread.php?t=308362.

 

[theDBguy]

how to do it ? storing the font(s) in a table as a BLOB

Yes. The instructions were here.