Line Feed in Report from Unbound Txtbox

N

NNlogistics

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?
 
N

NNlogistics

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?
Click to expand...
Click to expand...
 
N

NNlogistics

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?
Click to expand...
Click to expand...
Click to expand...
 
Top