admin管理员组

文章数量:1123182

I have a report that displays a number of fields, one of which is a LONG TEXT ouptut from a table. I am not doing anything to the data itself via query, other than retreiving it. I have validated that the DETAILS section has Can Grow/Can Shink both set to yes; the same is set for the text field of note. There is no specific point at which the text is being cut off per se, but its never complete.

If I tick both boxes (Grow/Shrink) to "NO" and make the box in the report large enough, its fine - however, it leads to a lot of extra (and unnecessary) white space.

  1. I have confirmed my report is less than the space available on the page with margins.
  2. Changing font or size for the text box wont work because its RTF and has formatting
  3. Converting to Plain Text isn't an option - having RTF in this field was a requirement.
  4. All of my boxes are tied to the grid in both location and sizing.
  5. Nothing is overlapping.

I tried to do something like this using the on format control, but it threw an error.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me!YourRTFFieldName.Height = Me!YourRTFFieldName.TextHeight
End Sub

本文标签: MS Access RTF truncating in Report Print Preview (And Prints)Stack Overflow