Home » Developer & Programmer » Forms » text box question
text box question [message #226545] Sat, 24 March 2007 21:15 Go to next message
1821
Messages: 40
Registered: November 2005
Member
Hey guys, I have created a text box on a form which is used to check for certain input and then based on that input the user will be taken to a certain form. However if the text box is left blank they will also be taken to the form is there anyway to prevent this?

I just can't figure out how to check for no input.

Thanks for any help.

[Updated on: Sun, 25 March 2007 13:56]

Report message to a moderator

Re: text box question [message #226927 is a reply to message #226545] Mon, 26 March 2007 23:44 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post your code.

Use an 'IF' test to see if there is any data in the field.

David
Re: text box question [message #227002 is a reply to message #226545] Tue, 27 March 2007 01:54 Go to previous messageGo to next message
1821
Messages: 40
Registered: November 2005
Member
Hi thanks for your reply, the code is along the lines of

IF :textbox = 'something'

then open_form(d:\test)

etc


I have tried if :textbox =' ' and if :textbox = NULL

however none have helped me ensure that input has to be made.
Re: text box question [message #227277 is a reply to message #227002] Tue, 27 March 2007 19:39 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Try testing for the field NOT being null or empty. Do you WANT them to go to another form if it is empty or NOT want them to go to another form?

David
Previous Topic: oracle apps forms ?
Next Topic: enable disable
Goto Forum:
  


Current Time: Sun Feb 02 12:46:02 CST 2025