Line Feed in Report from Unbound Txtbox

G

Guest

I have a form with a unbound txtbox. I want the input to be free form
including line feeds. Which I found can be accomplished at input with a cntrl
Enter combination. I then want to print this input on a report exactly how
it was entered on the form. It only prints on one line. Is there any way to
accomplish this?
 
G

Guest

In the Report (rptShipNotice) there is an unbound text box with the control
source set to =[Forms]![frmShippingNoticeSetup]![txtBillToBox] which is the
form (frmShippingNoticeSetup) that has the free form text box.

Thanks for all your help Doug
 
D

Douglas J. Steele

That works fine for me, as long as the CanGrow property for the text box in
the report is set to True.

I don't know what to suggest.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



NNlogistics said:
In the Report (rptShipNotice) there is an unbound text box with the
control
source set to =[Forms]![frmShippingNoticeSetup]![txtBillToBox] which is
the
form (frmShippingNoticeSetup) that has the free form text box.

Thanks for all your help Doug
--
Thanks for any assistance


Douglas J. Steele said:
How are you assigning the text from the form to the report?
 
G

Guest

Thanks Doug, I'll retrace my steps
--
Thanks for any assistance


Douglas J. Steele said:
That works fine for me, as long as the CanGrow property for the text box in
the report is set to True.

I don't know what to suggest.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



NNlogistics said:
In the Report (rptShipNotice) there is an unbound text box with the
control
source set to =[Forms]![frmShippingNoticeSetup]![txtBillToBox] which is
the
form (frmShippingNoticeSetup) that has the free form text box.

Thanks for all your help Doug
--
Thanks for any assistance


Douglas J. Steele said:
How are you assigning the text from the form to the report?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Yes in both the report and unbound text box in the form.
--
Thanks for any assistance


:

Have you set the text box's CanGrow property to True in the report?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have a form with a unbound txtbox. I want the input to be free
form
including line feeds. Which I found can be accomplished at input
with a
cntrl
Enter combination. I then want to print this input on a report
exactly
how
it was entered on the form. It only prints on one line. Is there
any
way
to
accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top