Question Report & Print Record of Database Changes

[GeoffT]

I want to make a note of changes I have made to a database, to be kept in the database for the benefit of any future programmer(s).

I thought the best way was to set up a table with one field - a text memo field, and an overlying form.

Obviously no problem there and happily recorded changes so far.

However, when I came to put this on a report and then print it out I can only print the text contained within the physical size of the derived field on the report layout.

Is there any way I can have a report that will automatically expand an object that is bound to a memo field so as to show the entire content of that memo field ?

 

[pbaldy]

I do something similar, but I use my version control table, so I also have fields for version number and date. You should be able to set the textbox Can Grow property to Yes (you may also have to set the property for the section it's in).