Printing a memo box in full on a form

[Emma Kirk]

im doing a piece of coursework on microsoft access, and would like to know how to print a memo box on a form in full, because the memo has basically an unlimited character format on it, and the box isnt that big, as the purpose for the course work is for a client card for a veterinary clinic, and i need the memo box to be able to print out the clinical history.

[ADezii]

I don't think that you really can, Emma. What you can do is:

1. Create a Report based on the same Row Source as the Form, but Filtered for the Current Record.
2. Create a Text Box on the Report Bound to the underlying MEMO Field by setting its Control Source equal to the Field.
3. Set the Text Box's Can Grow Property to Yes.
4. Print the Report, the contents of the MEMO Field will be displayed in its entirety.

[Emma Kirk]

thanks, but, i found a similar way of using the report, as i used a query which i made unique by using the square brackets command the client id and surname and linked it to the report, with the pet details and clinical history so i could print it out in a report :)

[ADezii]

Good for you, Emma.