OraFAQ Forum: Forms » How to change width of a column in Oracle Forms at run time

Home » Developer & Programmer » Forms » How to change width of a column in Oracle Forms at run time (Oracle forms 10g ,Window 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change width of a column in Oracle Forms at run time [message #631704]

Mon, 19 January 2015 00:15

nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida

Junior Member

Hi

I have a request from one of our users to increase width of a column at run time.Can anybody tell me the step,how to implement this function ?

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631709 is a reply to message #631704]

Mon, 19 January 2015 01:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use SET_ITEM_PROPERTY built-in & its WIDTH property.

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631726 is a reply to message #631709]

Mon, 19 January 2015 03:46

nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida

Junior Member

Hi Littlefoot

Is there any way to Change column width by user in run time like we did in excel to change A,B,C and other Column Width .

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631728 is a reply to message #631726]

Mon, 19 January 2015 04:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forms is not Excel. As far as I can tell, built-in I already suggested is the only way to do that. I guess that you can create a parameter (block item) which will enable users to set width they are satisfied with. That could be a text item, or a list item with predefined values, or whatever you find appropriate.

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631732 is a reply to message #631728]

Mon, 19 January 2015 05:08

nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida

Junior Member

HI

Please find attached standard form screen shot .In the screen shot I am able to to changed the width of column . I want to implement same function in my custom form.

Attachment: Screen Shot.png
(Size: 69.15KB, Downloaded 1636 times)

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631736 is a reply to message #631732]

Mon, 19 January 2015 05:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which tool (name and version) has been used to create that form?

Once again: as far as I can tell, Forms itself can't do it that way. I might be wrong (because I don't know any better), so - wait a little bit longer, someone else might have the answer you are looking for.

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631863 is a reply to message #631736]

Wed, 21 January 2015 01:08

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Workaround : A push button header

Click the right part ( you do computation on button length) and increase the size
if the left part is clicked then decrease

Report message to a moderator

Re: How to change width of a column in Oracle Forms at run time [message #631973 is a reply to message #631732]

Thu, 22 January 2015 08:48

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

nikita.rathore09 wrote on Mon, 19 January 2015 04:08

HI

Please find attached standard form screen shot .In the screen shot I am able to to changed the width of column . I want to implement same function in my custom form.

Your best option would be to open the Oracle supplied EBS form and find the code they use. My guess is that they are using a Java Bean versus a native Forms Widget.

If Oracle has documented how to use this feature, then it will be in the Oracle E-Business Suite Developer's Guide; which can be found in the Oracle EBS Documentation Web Library ( http://www.oracle.com/technetwork/documentation/applications-167706.html ).

Craig...

Report message to a moderator

Previous Topic:	import excel Data By column using oracle 6i form
Next Topic:	Forms10g : Make Text Item not editable but clickable?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 10:47:13 CST 2025