Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

format mask 999D99 in Oracle Form issue

634672Jan 23 2009 — edited Jan 23 2009
I have a textbox in Oracle form, with format 999.99 => means that we can input 0.99 0r 100.00

But now, I want to input only as 100 or 0.99, I don't want any .00 if i type 100.
Just i want 100 as 100 and 100.1 as 100.1 and 100.11 as 100.11. I don't want 100 as 100.00

i have tried format masks like 990D00 , 999.99, B999D99 , B990D00, 990D99, but all the formats is displays input 100 as 100.00, Please let me know which format mask will resolve my issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2009
Added on Jan 23 2009
5 comments
6,701 views