Significant digits

[Andy]

Is it possible to build a macro that will adjust or accept significant digits
in an entry field input based
on the value in another.

I am trying to achive the following,.. if Price is then significant digits
are as follows

[PayItem]![Quantity] [Inventory]![ProductCost]

0.1 $0.1 to $9.99
0.01 $10.00 to $99.99
0.001 $100.00 to 1000.00
0.0001 $1001.00 to 10000.00
0.00001 $10001.00 to Infinity

[PayItem]![Quantity] is long intiger and [Inventory]![ProductCost] is Number
$ field.

Is this possible?

 

[John W. Vinson]

Is it possible to build a macro that will adjust or accept significant digits
in an entry field input based
on the value in another.

I am trying to achive the following,.. if Price is then significant digits
are as follows

[PayItem]![Quantity] [Inventory]![ProductCost]

0.1 $0.1 to $9.99
0.01 $10.00 to $99.99
0.001 $100.00 to 1000.00
0.0001 $1001.00 to 10000.00
0.00001 $10001.00 to Infinity

[PayItem]![Quantity] is long intiger and [Inventory]![ProductCost] is Number
$ field.

Is this possible?

No, since a) a Long Integer field is by definition a whole number and cannot
use decimal places, and b) there is no such thing as a "Number $" field.

I have no idea what you mean by the question, frankly.