OraFAQ Forum: Forms » Format for SSN field

Home » Developer & Programmer » Forms » Format for SSN field

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

Format for SSN field [message #466087]

Fri, 16 July 2010 14:44

coolguy01
Messages: 64
Registered: August 2006

Member

I have a ssn field where the user enter value to search for the ssn. I want to format the field so the user can enter in the xxx-xx-xxxx format only. If the user enters a wrong format and tries to search i should prompt a message saying wrong format. How can i achieve this.

Thanks

Report message to a moderator

Re: Format for SSN field [message #466127 is a reply to message #466087]

Sat, 17 July 2010 02:30

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear ,

Can you let me know your SSN stored values in database are also in this format 123-22-4567 ?

Report message to a moderator

Re: Format for SSN field [message #466145 is a reply to message #466127]

Sat, 17 July 2010 04:24

cookiemonster
Messages: 13973
Registered: September 2008
Location: Rainy Manchester

Senior Member

By using the format mask property. Form builder help will give you all the possibilities with examples.

Report message to a moderator

Re: Format for SSN field [message #466562 is a reply to message #466145]

Tue, 20 July 2010 02:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/mv/msg/158871/465023/67467/#msg_465023

David

Report message to a moderator

Previous Topic:	FRM-40735, ORA-06508
Next Topic:	how to Hid the Pause message "Please acknowledge". (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 30 21:49:06 CST 2025