AnsweredAssumed Answered

Problems creating a report with a very large text field

Question asked by RBowering on Nov 8, 2014
Latest reply on Nov 9, 2014 by philmodjunk

Title

Problems creating a report with a very large text field

Post

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)

FM2.png

Outcomes