[AccessD] Coordinating use of space on report

Courier is ugly and takes more space than, say, Arial narrow.  But everybody
has it, AFAIK.  And it's fixed width.   

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Friday, August 03, 2007 2:25 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Coordinating use of space on report

Hi.  I would appreciate any bright ideas on a very specific requirement.

On a report, I have a strictly limited width for some data.  This data is in
2 fields.  The data in the left field will be left aligned, and the data in
the right field can be right aligned.  It's the name of a sports team, and
their score in a competition.

The number of characters in the score can vary quite a bit.  It could be
like any of these:
2
234/9
25 (WBC)
LBD

In some cases, the name of the team will need to be truncated in order to
fit.  That's ok.  Growing the control height is not possible.

But I don't want to have to make the right-hand control wide enough to cater
to the widest possible score data.  This would mean reducing the amount of
space available for the team name, which in most practical cases would
restrict it much more than necessary. In other words, I don't want to make
*all* the team names narrow enough so that a score of
25(WBC) could be fitted in, when in most cases the score will be more like 2
allowing a wider team name and possibly preventing truncating. 
Hope that makes sense.

I have played with the idea of using fixed width font, and concatenating the
team and score into one control, with the requisitre number of spaces in
between to justify the text.  2 problems with this:  Fixed width fonts
generally take up more space anyway, for the same amount of text.  And this
report is output to PDF and for internet download, so many users who will be
trying to print it will not have that font installed.

So... what would you try?

Regards
Steve
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.2/933 - Release Date: 8/2/2007
2:22 PM