trying to do negative number in an input mask

[sparks]

Can you do this.

We have some fields with double set and an input mask of

fixed
decimal place 2
input mask ###.##

works great..

but now we have one field that can be a pos or neg number.

how in the world do you make an input mask to take this?

do you have to just go to a double with no format and let them type in
whatever?

[spier]

On May 31, 3:25 pm, sparks <[e-mail]:

Can you do this.

We have some fields with double set and an input mask of

fixed
decimal place 2
input mask ###.##

works great..

but now we have one field that can be a pos or neg number.

how in the world do you make an input mask to take this?

do you have to just go to a double with no format and let them type in
whatever?

Just type in your value, e.g. -1.33 ( will look -1 .33 - a space
between 1 and dot).
If you need to enter a value like -123.45, then you have to increase
the input mask: ####.##

[sparks]

Thanks for pointing that out.

it was set up as ##.##

one of the people called and said BUT that field can have negatives.
I looked in the format help and was reading one thing and NOT the #
definition.
IT WAS STUPID on my part. Now I know how Homer feels..
D O H
On Fri, 01 Jun 2007 12:28:16 -0700, spier <sp*****@yahoo.comwrote:

>6 GMT)
X-Complaints-To: gr**********@google.com