Auto resize memo field in subform

mardi 28 avril 2015

Hello,

I have searched endlessly to see if this is possible... I have a subform that I use in a few different ways on my database. It has a comment log with a memo field for people to insert their comments. The struggle is some can be long some can be short. Is there any way to have each record height adjust to the length of the memo?

If it cannot be done for the subform in regular use, my main concern is having it formatted for reports that are generated for clients.

I clipped and attached an example from a report. Its not hte best example but the extra column height is adding additional pages to my report to accommodate one long comment.

What are my options? BTW, I am fairly new to VBA / MS access

Thanks

Attached Images
File Type: png Capture.PNG (54.2 KB)
Auto resize memo field in subform

0 commentaires:

Enregistrer un commentaire

Labels