Peter, Yes.... same problem here. With a monospaced font you can do that but they don't want that type of font as it looks totally out of place and takes up too much space so I'm left trying to work out a solution for variable spaced fonts. The problem is even more-so as the rendering of fonts on the screen is different to that on the printer so I can give the screen operator a fixed space to enter data into but if I duplicate that field size (memo field) on a report then the space taken up is different! Grrrr!
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Peter Cushing Sent: 26 February 2014 16:09 To: [email protected] Subject: Re: Fitting text into a fixed space Dave Crozier wrote: > Gentlemen, > I wonder if any of you have come across this problem before and successfully > solved it. > > We have a works "spec sheet" that defines each parameter of a customer job > and prints out on a SINGLE sheet of A4 all the parameters that a machine > operator requires. Some of this data is not fixed length i.e 2 fields that > are purely descriptive so in the space we have available for each field we > need to display the data in the largest font available for the space > available. Note that this is in a report and I can use a udf to change the > font of a field before it is printed using the Report Listener. > > However, I have had mixed success using the sysmetric and fontmetric calls in > order to determine how large the font should be. > > Anyone else solved this problem? > > Not solved the problem using sysmetric or fontmetric but what about having your own rules to determine the size of the font. Depending on the number of lines for the two fields and how wide they go just apply successively smaller fonts as they hit certain limits. Not actually tried variable fonts myself (yet) and this would need some testing but just an idea. Peter ---------------------------------------------------------------- Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.com Please update your address book with my new email address: [email protected] . This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
