Report Field Length

Robm1955

I am creating a report in Access 2003, and I need to make some of the fields smaller, as the report is spilling over onto the next couple of pages. Without keep changing the control lengths, is there a way of automatically setting the length of the control so the text fits. Without going through every record, I don't know what the maximum number of characters in a control is.

fergual2

One suggestion in properties of control change font size to be smaller so more text fits in it.


On the other point of going through all records, the max length of a column of data stored in a table/query can be retrieved in a query with SQL statement like:-
SELECT max(len(lname))
FROM Table1;



where lname is the field name and Table1 is table/query name.