Breaking the 127 point font size barrier with MS Forms 2.0 OCX and VB6

[frasmus44]

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.FontSize = 250
Me!myControl.FontWeight = 600
Me!myControl.WordWrap = 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.

[Salad]

frasmus44 wrote:

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.

Is there enough space to print with borders? Check your
File/PrintSetup and ensure your borders aren't a source of the problem.

[Stephen Lebans]

A couple of options:

1) Use the RotateText ActiveX control on my site with zero degrees of
rotation. Works for both Forms and Reports and can be bound to a field.

2) For Reports only, use the Print method of the Report object to draw
the text yourself.

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"frasmus44" <mh**********@spammotel.com> wrote in message
news:f8**************************@posting.google.c om...

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.FontSize = 250
Me!myControl.FontWeight = 600
Me!myControl.WordWrap = 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...port.microsoft.
com:80/support/kb/articles/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.

[david epsom dot com dot au]

There has been at least one version of Forms 2.0 released after
VB6. I don't know if it was rebuilt to fix this fault.

FM20.dll 2.1.9922.1 March 23 2003

(david)

"frasmus44" <mh**********@spammotel.com> wrote in message
news:f8**************************@posting.google.c om...

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.FontSize = 250
Me!myControl.FontWeight = 600
Me!myControl.WordWrap = 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.