Formatted TextBox on Form to Report

[Addammer]

On my Form I'd like to have a textbox that I could type something like the following...

Hi, My Name is Adam
Here is my favorite sport: Soccer
I'd like to find out what other people's favorite sports
Please send me an email back with your answer

Keep in mind the above could be one line, or it could be 20.

How can I transfer all the hard/soft returns etc. into a text box when I view and print the report?

Hope that made sense.
Thanks!

 

[Moniker]

Here you go. I timed myself on this one. 3m27s. Ha!

Short version of it:

1) Make a table containing the information you want.
2) Make a form based on that table. Add the fields you want the user to edit.
3) Build a report on the same table.

As a test, I copy/pasted your sample text into the main form (f_Main) and then clicked Show Report.

 

[Addammer]

Moniker

Thank you for you thoughts!

I've actually found what I needed.

1. create new text box on Form1
2. create new text box on Report1
3. Make the control source of both txtDescription
4. on Form1's text box property's choose "Other" tab then set "Enter Key Behavior" to New Line in field.

Then when I open my report. Wa-la! the text is there with returns!

Thanks!