Home » Developer & Programmer » Forms » HELP: Format Mask
HELP: Format Mask [message #235815] Tue, 08 May 2007 01:37 Go to next message
Full Moon
Messages: 5
Registered: May 2007
Junior Member
Hi everybody, I am a new member and I ‘m facing this problem actually I did researches in your web sit, but I did not find anything close
How I can remove the space between the currency and number

I have this field type number, it format mask is “$” 9999.99
For example, if enter 66 then the outcome will be like $ –66.50

Any one can help me Plzzzzzzzz

Full Mooooooooooon
Re: HELP: Format Mask [message #235822 is a reply to message #235815] Tue, 08 May 2007 01:51 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
I can't understand your question ,can you repeat again?

you enter 66 and you are looking for -66.50? confusing
Re: HELP: Format Mask [message #235833 is a reply to message #235822] Tue, 08 May 2007 02:10 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
Did you try $99999.99

but it will display -$66.50

Re: HELP: Format Mask [message #235845 is a reply to message #235833] Tue, 08 May 2007 02:45 Go to previous messageGo to next message
Full Moon
Messages: 5
Registered: May 2007
Junior Member
yes, I tried that

For example when i enter 99.50
the outcome will be like this $--99.50

-- means space, so i don't want space, i want the outcome to be like this $99.50


Re: HELP: Format Mask [message #235852 is a reply to message #235845] Tue, 08 May 2007 02:59 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I think it is a valid format mask.

$99,999.99

it does not return space.

dont use "$"9999.99
Re: HELP: Format Mask [message #235855 is a reply to message #235815] Tue, 08 May 2007 03:08 Go to previous messageGo to next message
Full Moon
Messages: 5
Registered: May 2007
Junior Member
Thank you I Will try it and see


Full Moon
Re: HELP: Format Mask [message #235857 is a reply to message #235855] Tue, 08 May 2007 03:11 Go to previous messageGo to next message
Full Moon
Messages: 5
Registered: May 2007
Junior Member
any one Know a good ASP Forum
Re: HELP: Format Mask [message #235959 is a reply to message #235815] Tue, 08 May 2007 09:20 Go to previous messageGo to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hello there


I had the same problem as yours Full Moon

kamran.it

I tried your solution but it didnt worked

seting the format mask as $99,999.99 is not accepted an error message appear

waiting your replies

----
lune

Re: HELP: Format Mask [message #236049 is a reply to message #235959] Tue, 08 May 2007 16:08 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, such an example doesn't leave any space between '$' and first digit.

/forum/fa/2421/0/
Re: HELP: Format Mask [message #236062 is a reply to message #236049] Tue, 08 May 2007 22:58 Go to previous message
Full Moon
Messages: 5
Registered: May 2007
Junior Member
thank you, i will try that

[Updated on: Tue, 08 May 2007 22:58]

Report message to a moderator

Previous Topic: How i can validate item in post query
Next Topic: how to use HOST command
Goto Forum:
  


Current Time: Sun Feb 02 12:59:50 CST 2025