Larger font size than 127 possible?

[Asbjørn Søbye]

I'm making a database for archery events. When we set up the field we would
like to have the shooters name on the relevant face he's shooting at. Indoor
distance is 18 m and due to that it's important that the print of his name
is as big as possible.

I have a code that automatically resize the font so it fits within the
control, but it is still limited to fontsize 127. Does anyone know if there
is a way around this? Excel or Word doesn't seem to have this limitation,
but it would be a timeconsuming job to print all the names using those
programs. Or maybe not? Anyone have a good idea on this?

Thanks.

Regards
Asbjørn Søbye

 

[Stephen Lebans]

From: Stephen Lebans - view profile
Date: Mon, Aug 2 2004 12:15 pm
Email: "Stephen Lebans"
<[email protected]>
Groups: microsoft.public.access.reports
Not yet ratedRating:
show options


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)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.

 

[Asbjørn Søbye]

I see this gives me possibilities for bigger fonts, but then I'm back to
manualy adjusting fontsize based on the length of the shooters name since my
code ... :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim lngret2 As Long 'For Name Control

lngret2 = fMakeFitSingle(RotateLabelVer26, 127)

End Sub

.... gives me runtime error '438': Object doesn't support this property or
method

But I'm on realy thin ice here since I have limited knowledge of
programming.

I have 270 names in the database and each name shall fill the control as
much as possible by automaticly adjust the fontsize (hopefully without the
limitation of fontsize 127).

With regards to your second sollution, I have no idea how to do that, but it
sounds like a lot of work?

Regards
Asbjørn Søbye

 

[Stephen Lebans]

Were you able to resolve your issue?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.