Oracle Forms

hi

h6.
am using 6i forms,In my form there is a text item where user enters some detailed content. For example

" Desktop virtualization using Sun Ray technology can make a huge impact on workflow. 
 In medical offices or hospitals, for example, doctors or other medical technicians using 
Sun Ray technology can move electronic patient records from bedside to
 lab to office without breaking stride.



 "

the blank space in last part was created by pressing enter key in the text item by user. I want to avoid those extra enter key chr(10) before inserting to
database .

I tried as follows
h5.
:text_desc:=trim(chr(10) from text_desc); in pre-update.but its showing error .
h5.
I want to store the content after eliminating the extra enter key followed by last word .
h5.
Here in the example the last word is stride


Please suggest a way

Thanks
:)

Edited by: SunFlower on Jul 6, 2010 11:38 PM