Jane-
I seem to remember there's a Windows API you can call to find the length (in
Twips) of a string in a given font. But I can't seem to find it at the moment.
There is supposedly a TextWidth property for controls on a report, but it
doesn't seem to work.
Anyone else have an idea?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jane
Sent: Friday, January 27, 2012 5:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Width of characters
Hi
I have to print a report onto a pre-printed sheet. One of the boxes on the sheet
is 8cm wide. Without using a fixed width font, is there anyway of determining
how wide text will print out on the form - obviously it will depend upon what
the user types & whether they use all uppercase.
After the user has entered text I would like a function to calculate the width
that it would print out (Arial, 9pt) & then let the user know if that's too much
- so they can abbreviate.
Any suggestions?
Many thanks
Jane
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar