You might try setting the "Can Grow" format property of the field to Yes. That will cause the field to auto expand when there is more text in the field than you have given room for.
The reason I am doing it in the On Open event is because the reports are being run from the switchboard.
I don't know of any way to make the table automatically before opening the report from the switchboard.
According to the Access Visual Basic help files the On Open event of a report takes...
I have a client that reported a problem with a report not having the correct data. The report is based on a table that is recreated in the OnOpen event, using a make table query.
When they ran the report it showed data from about a month ago. They then closed the report and reran it and this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.