Using input masks with positive or negative numbers

[vtuda]

First of all sorry for my English.
I can't find an input mask to show plus sign or minus sign on a numeric field. I've tried several masks like this:
+##.##;-##.## but they don't work. These in particular works very well formating cells in Excel but they don't in Access. I can't believe there is not an appropriate mask to work showing positive or negative sign in a number.

Thanks in advance.

Vianey Tuda

 

[67peshawar294]

Vianey,
Your english seems flawless to me. Try using 0's instead of #
+0.00;-0.00
Works well on my form.
Jim

 

[vtuda]

Jpeneh10:


Thank you so much for everything!. You're so kind. Now I have a new question: I've tried using your suggestion but I have noticed that plus signus only shows when I 'click' over the field. If I move to another record it disappears. I would like + signus to be displayed all the time just like it works with $ symbol. Is it possible?...

Best regards,

Vianey Tuda

 

[67peshawar294]

Vianey,
Your more than welcome.
Sorry, the +0.00;-0.00 should be in the "format" line, not in the "input mask"

Jim

 

[vtuda]

Jim:



WO

http://WWW!!!

Thank you, thank you so much !!!... And God bless you!.

Great people like you make great sites like this forum.



Vianey Tuda