Currency format and decimal places

Hi there,
I put 2 decimals in under decimal places in my table and yet I can enter as
many as I want and it rounds it off. I just want the user to be able to enter
2, thats all. Can I do this?

Also, can I have an Input mask with a currency, like space space comma space
dot
Like a postal code or date?

Thanks for your help!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

An Input Mask like:

999,999,999.00

will allow only 2 decimal inputs and a maximum amount of:

$999,999,999,99

and a minimum of:

$.00

Is that what you are looking for?

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"gmazza via AccessMonster.com" u37142@uwe wrote in message
news:9d4d2435700c2@uwe...
Hi there,
I put 2 decimals in under decimal places in my table and yet I can enter
as
many as I want and it rounds it off. I just want the user to be able to
enter
2, thats all. Can I do this?

Also, can I have an Input mask with a currency, like space space comma
space
dot
Like a postal code or date?

Thanks for your help!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

On Thu, 08 Oct 2009 20:43:53 GMT, "gmazza via AccessMonster.com" u37142@uwe
wrote:

Hi there,
I put 2 decimals in under decimal places in my table and yet I can enter as
many as I want and it rounds it off. I just want the user to be able to enter
2, thats all. Can I do this?

My guess is that the Datatype (not the format or the Decimal Places property,
which merely control the display) is the default Number datatype: Long
Integer. An Integer is by definition a whole number and it will round.

If you use a Currency datatype (rather than any sort of Number; it's one of
the choices like Text, Date/Time, Yes/No etc.) you'll get up to four decimal
places.

Also, can I have an Input mask with a currency, like space space comma space
dot
Like a postal code or date?

Sure. Probably a bad idea, for Currency data a mask will just make more work
for the users entering data. If you insist, you can use a Format property of
"Currency" or "#,##0.00#" and an Input Mask of "999,999.99".
--

John W. Vinson [MVP]

Thanks guys, thats exactly what I want, works great!!

Arvin Meyer [MVP] wrote:
An Input Mask like:

999,999,999.00

will allow only 2 decimal inputs and a maximum amount of:

$999,999,999,99

and a minimum of:

$.00

Is that what you are looking for?

Hi there,
I put 2 decimals in under decimal places in my table and yet I can enter
[quoted text clipped - 9 lines]

Thanks for your help!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1