What do you want it to do? If this column actually holds currency values but

you want to allow entry of only whole dollar amounts then probably a better

approach would be make it a Currency data type and set its ValidationRule

property to:

=Int([YourField])

and give it an appropriate ValidationText property.

For all you ever wanted to know about rounding, and a lot more you probably

didn't, have a look at:

http://www.pldesignline.com/howto/showArticle.jhtml?articleID=175801189
To give you a flavours here's what it says about 'banker's rounding':

"Round-half-even: If half-way values are always rounded in the same

direction (for example 3.5 rounds to 4 and 4.5 rounds to 5), the result can

be a bias that grows as more rounding operations are performed. One solution

toward minimizing this bias is to sometimes round up and sometimes round

down.

In the case of the round-half-even algorithm (which is often referred to as

Banker's Rounding because it is commonly used in financial calculations),

half-way values are rounded toward the nearest even number. Thus, 3.5 will

round up to 4 and 4.5 will round down to 4. This algorithm is, by definition,

symmetric for positive and negative values, so both -3.5 and -4.5 will round

to -4.

In the case of data sets that feature a relatively large number of

"half-way" values (financial records provide a good example of this), the

round-half-even algorithm performs significantly better than the

round-half-up scheme in terms of total bias. However, in the case of data

sets containing a relatively small number of "half-way" values â€“ such as

real-world values being applied to DSP algorithms â€“ the overhead involved in

performing the round-half-even algorithm in hardware does not justify its use

(see also the filter examples shown later in this paper)."

Ken Sheridan

Stafford, England