OraFAQ Forum: Forms » LOV ATTACHED TEXT BOX SHOULD BE NON EDITABLE

Home » Developer & Programmer » Forms » LOV ATTACHED TEXT BOX SHOULD BE NON EDITABLE

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

LOV ATTACHED TEXT BOX SHOULD BE NON EDITABLE [message #143158]

Wed, 19 October 2005 05:42

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

Hello. I want to return the LOV selection to a textbox, but I don't want the user to be able to edit that textbox manually. When I make the textbox disabled, the LOV no longer works! Sad

Is there a way I can get the result from an LOV, but still have the textbox so that it cannot be edited manually?

Thanks,
Meena

Report message to a moderator

Re: LOV ATTACHED TEXT BOX SHOULD BE NON EDITABLE [message #143203 is a reply to message #143158]

Wed, 19 October 2005 08:25

del_sandy
Messages: 22
Registered: February 2005
Location: Delhi

Junior Member

Hi Meena,
To make ur LOV attached text box uneditibale,
Set Property of text item as follows..
Insert allowed No
Update Allowed No
Query Allowed No
Update only if Null Yes.
And use code to raise LOV on Key-Next-Item Trigger
E.g.
declare
show boolean;
begin
show:=show_lov('LOV_NAME');
End;
Hope it will work for u.
Cheers
Sandy

Report message to a moderator