Reporting issues

  • Thread starter Thread starter Aaron Neunz
  • Start date Start date
A

Aaron Neunz

I am building a report using a table containing 5000 names. Is there a way
I can verify, before printing, that the width of my text boxes are wide
enough so as to not cut off the contents of a record?

Thanks,
Aaron Neunz
 
Sure, but CanGrow only affects the vertical size, not width.

Run a query to tell you what the maximum length of your current names are:

SELECT Max(Len([Name])) AS NameLength, Max(Len([City])) AS CityLength
FROM datContacts;

Then do your best to size the text boxes accordingly.

Keep in mind that you are probably dealing with non-proportional fonts: the
letter i takes up a different amount of space than the letter w. That being
the case, a text box designed to be wide enough to handle *most* 25
character entries isn't guaranteed to handle *all* 25 character entries. You
could make it wide enough to handle the worse case scenario (which may never
happen), but that might be "wasting" valuable space. Trade-offs galore.
 
Back
Top