How to hide decimals in the form field

[azhar2006]

I try to write user number without separator (925) only
Because in this place, if it becomes an error in entering numbers or inefficient user using the comma
Will be a disaster in the total amounts

[azhar2006]

Any solution
Please, help
I can change all the expressions in the query
Except expressing (IOunce: ([Ounce] / 31.1))
Because it is a global

[June7]

I gave you an expression that will remove the decimal point, if it is there. Did you try it?

Or you can modify the expression to include decimal point:

IIf(InStr([purity], ".")=0, [purity] / 1000, [purity])

Use whichever suits your requirements.

[azhar2006]

1 troy ounce = 31.1 grams

Precious metals such as gold and silver are often sold by the troy ounce. Many people don’t realize that an ounce of gold (and other precious metals) is weighed in a different weighing system called "troy weights". A troy ounce is more than the typical ounce found at the grocery store.
The other is for Commodities such as sugar, grains, and the typical grocery items. It is called the avoirdupois ounce.

1 avoirdupois ounce = 437.5 grains, or 28.35 grams. 1 avoirdupois pound contains 16 (avoirdupois) ounces. This makes an Avoirdupois pound equal to about 453.6 grams, or the equivalent of 14.583 "troy ounces".

When you purchase a 1 ounce silver or gold coin, you are receiving a "troy" ounce. If you put that same 1 troy oz. coin on a grocery store scale you will find that it weighs about 10% more than the food (avoirdupois) ounce you are familiar with. It will weigh about 1.1 avoirdupois ounces. A troy ounce is equivalent to about 31.1 grams.

[azhar2006]

Any solution
Please, help
I can change all the expressions in the query
Except expressing (IOunce: ([Ounce] / 31.1))
Because it is a global

[azhar2006]

Yes Yes Yes
And woowoo
Thank you very much June7
You are gorgeous