how to Control a textbox 1

[jhoann]

Hi,

I have a button and a textbox :

(1)
mybutton = my pl/sql is like this inside "when button pressed":

:b_1.prev_mem :=
'*Office & Facilities*'||
'================'||
'Previous Contact Details'||
'------------------------'||
'Address : '||:b_1.co_addr||
'Tel No : '||:b_1.co_tel||
'Fax No : '||:b_1.co_fax;

(2)
mytextbox = name is "prev_mem"
it is a CHAR, length 500

so if you press mybutton, mytextbox (prev_mem) will contains:

'*Office & Facilities*'||
'================'||
'Previous Contact Details'||
'------------------------'||
'Address : '||:b_1.co_addr||
'Tel No : '||:b_1.co_tel||
'Fax No : '||:b_1.co_fax;

(3)
my problem is I want it to be in that format same as above but what my output is it's very close to each other like this:
*Office & Facilities*===================Previous Contact Details-------------------Address : 4100 Benitez St Binondo Manila NCR 1006Tel No : 123456Fax No : 2-3333333

how to control the textbox to format the output like this:
*Office & Facilities*
===================
Previous Contact Details
-------------------
Address : 4100 Benitez St Binondo Manila NCR 1006
Tel No : 123456
Fax No : 2-3333333

i hope you can help me!

thanks
Jhoann

 

[mobeen]

textbox's multilines property = Yes then use chr(10) by following way.

'*Office & Facilities*'|| chr(10)
'================'|| chr(10)
'Previous Contact Details'||chr(10)
'------------------------'||chr(10)
'Address : '||:b_1.co_addr||chr(10)
'Tel No : '||:b_1.co_tel||chr(10)
'Fax No : '||:b_1.co_fax;

i think it will help you.
regards,
mobeen.

 

[jhoann]

Hi Mobeen,

it's great...it works

thanks a lot.. it really helps


Jhoann