Home » Developer & Programmer » Forms » format mask
format mask [message #87845] Wed, 16 February 2005 09:48 Go to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
I need to set the current format mask to non. How do I do that?
Re: format mask [message #87864 is a reply to message #87845] Fri, 18 February 2005 00:58 Go to previous messageGo to next message
a
Messages: 22
Registered: March 2002
Junior Member
if u want to dothis at run time use then

set_item_property('item_name',format_mask,9999);

else

just keep that propery blank ;

end if;
Re: format mask [message #87869 is a reply to message #87864] Fri, 18 February 2005 03:29 Go to previous messageGo to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
Thanks for the help, but what do you mean, "keep that property blank"? Blank as in, ' ' (empty quotes) or null or what?
Re: format mask [message #108964 is a reply to message #87869] Sun, 20 February 2005 20:38 Go to previous messageGo to next message
a
Messages: 22
Registered: March 2002
Junior Member
null but dont write null there
Re: format mask [message #109025 is a reply to message #108964] Mon, 21 February 2005 04:42 Go to previous messageGo to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
I have a database phone number field on a form which holds a phone number (length 7-15 digits). I have to put a mask on this field, which depends on the number of digits the user enters in the phone field. I am using SET_ITEM_PROPERTY to do this. Now the user may or may not enter dashes, so input can be in the form 9999999999 or 999-999-9999.The number field will not allow the user to enter 999-999-9999 because it sees the dashes as a minus sign and I am getting an error, which I cannot handle in When-Validate-Item, because Validate item is firing before. How do I get around this?
icon6.gif  Re: format mask [message #109101 is a reply to message #109025] Tue, 22 February 2005 01:30 Go to previous message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

hay

i'm stupid person i dont understand such complicated problems

but u can try this format mask

099"-"99"-"9999



ashish Rolling Eyes
Previous Topic: rowid in forms
Next Topic: Label don't show the changes!
Goto Forum:
  


Current Time: Mon Sep 16 16:38:09 CDT 2024