Microsoft Access - Override Maximum Font Size?

Question

Have a Access 2007 database which needs to have a report that prints out some really big numbers (for some signage). Currently in Excel the template uses a 400 point font size. When trying to change the font size in Access the following error message appears:

The setting of the FontSize property must be from 1 through 127

I tried adding some VBA code:

Me.Text0.FontSize = 400

But this results in the same error message.

Is there anyway to programmatically override the font limitation? Or is it so hardcoded into Access that it can't be bypassed?

Answer 1

Hmm... I'd use a litle automation and send the output not to an Access Report, but to a Word document. Then you'd not have the font size limitation.

Don't try and make Access do something it can't do, find something that can do it, and have Access ask it to do it!