Problems creating a report with a very large text field
I’m hoping this query is simple
I’ve built a database for a counsellor that I know
The tables are Counsellor -< Client -< Session
One of the database tables is ‘Session’
This includes the fields
Session ID (autonumber)
Date of Session (date)
Time of session (time)
Session notes (text field)
(among other fields)
The Session Notes can be as long as she wants and I’m testing by putting a very long document in the field by cutting and pasting in the text.
She wants to be able to print the record (a single Session record) so I’ve made a simple layout containing those fields. But it never shows more than 1 page even if the Session Notes data is bigger than the field layout ‘box’.
How can I tell the layout that it should print as many pages as necessary to incorporate all the session notes
(To be clear I’m assuming just one session record here)