Size text box in Access Report to fit length of Memo field

[2781]

Hi,

I want to print a memo field in an ACCESS report. This memo field contains sometimes only a few words, but is at other times several pages long.

How would one develop a macro or VBA procedure to adjust the length allocated to the memo field on the report to the actual size memo field.

Or does such a routine already exist out somewhere?

I have tried Format/Size/To fit, but this seems only applicable to labels.

 

[Monguse]

Access has a 'MEMO' Data type built in and will take a very large "Memo" there is a limit but I don't remmber it offhand.

and VB in VB I would suggest using a RichTextBox for the Memo.. "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson

WebMaster:

http://www.firearms-for-us.org

 

[chadt]

The memo field excepts 65K characters or something close to that. As for generating reports with the memo field I would highly suggest using crystal reports against the Access DB.

chadt@techtnologies.com