MS Access 2003 SP2
This database fills blanks on a US Customs form. The Port Director has asked that I increase the font size on the entry fields so that it is easier to read when the fax is received. (I know, there are 100 ways to email it and get a "pretty" copy, but they require the fax.)
Increasing the font size causes some records to extend beyond the allotted space on the form, cutting off portions of the data.
For example: "Dublin, Ireland" fits fine, but "Purfleet, United Kingdom" gets cut off.
1) I cannot wrap the text.
2) I cannot modify the alloted size of the field.
I would like for the control to use font size 12 for everything that will fit, and either 11 or 10 based on the length of the data. (I have determined that 10 is the smallest necessary.)
What I need is some combination of conditional formatting and whatever flags the "Can Grow" attribute.
I need to get this in production immediately, so any ideas will be greatly appreciated.