Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a report that has fields in it for sending a letter to
recipients in the data base consisting of name, address etc.

I want the user to be able to type the body text when running the report. I
have used a text box prompting the user to type the text. However, there is
a restiction on the number of characters that can be typed in and the layout
is all over the place.

Is there a way that the user can be prompted to type the body text so that
it is formatted correctly with provision for new paragraphs etc.

Thanks for any help
 
IF I were to do such a thing, I would probably present the user with a form
and an unbound control so they could enter as much text as needed. If you
open the form in dialog mode it should allow them to input as much data as
they wish. Set the Enter key behavior to new line in field for the text box
so they can add line feeds.

Then instead of closing the form, I would set its visible property to false
( use a button to do this) and reference the control's form in the report
[Forms]![MyDialogForm]![MyTextBox]

When the report closes, I would close the form.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top