I have searched this group for ways to create jumbo fonts in my Access
forms and reports. Unlike MS Word and MS Excel, Access has a 127 point
font limit. (About 1.75" tall) I'm referring to bound controls here,
so pasting a bitmap into the form is not a solution. I am using Access
2000 (9.0.4402 SR-1).
After playing with some ActiveX controls, I found the Microsoft Forms
2.0 textbox looked promising. I placed the control in a form and
assigned a control source under the object's data properties equal to
a field in my recordsource. Then I was able to manipulate the font
size with form's onCurrent event:
Private Sub Form_Current()
Me!myControl.Fo ntSize = 250
Me!myControl.Fo ntWeight = 600
Me!myControl.Wo rdWrap = False
End Sub
I couldn't figure out how to change the font style, but the default MS
Sans Serif is acceptable for my purposes.
Here's where the problem arose, and the reason for my post:
When you view the form on-screen, the control displays perfectly.
However, the control is either partially cut off or is blank when
previewed or printed.
After fumbling around for quite a while, I discovered the following
article in the MS KnowledgeBase that says this is a known bug of
UserControls (OCX) that are created in Visual Basic.
http://support.microsoft.com/default.../q181/8/77.asp
I'm not 100% sure this is the same situation, but the article says
that the Visual Basic virtual machine MSVBVM50.DLL is the cause and
VB6.0 solves the problem. I found both MSVBVM50.DLL and MSVBVM60.DLL
in my system32 folder, but I am not sure if Access is looking at the
right one. When I look at reference libraries, neither one is checked
and when I try to select either one, I get a "Name conflicts with
existing module, project, or object library" error. I cannot select
either one even in a new database.
It looks like I'm real close to figuring this out, but I've exhausted
everything I can think of, so I'm deferring it to the Access gods...
TIA,
Fr3d Rasmuss3n
Ordinary Guy w/Extrordinary Reputation thanks to MS Access and luck.