Presently in my formula I am using

sngIncr = (Me.TL - Me.MIN) / 17

How should I modify the formula (or what command should I
use) that would round of the number so no decimals show.

Additionally, is there a way that I can round up to the
nearest number ending in 5. E.g. if the results of mu
formula is 3072, I would like 3075 to be displayed.

Your assitance is appreciated.

Rob

>-----Original Message-----
>When you click, the actual value of the field will show.
If you want the
>value to be in whole numbers, then enter it into the
field as whole numbers.
>If it is a calculated field, then you will have to round
the results.
>
>The format is simply a way to change the way a number
looks. The underlying
>number is still the same.
>
>Rick B
>
>
>"Rob" <(E-Mail Removed)> wrote in
message
>news:f55401c43dd8$3b0e9c20$(E-Mail Removed)...
>I have created a form and set the format of the fields to
>currency with a 0 decimal places.
>
>When I go into form view I see the value as set e.g.
$1,234
>When I click in the field the view changes to $1,234.8366
>
>What properties do I set so the display stays at $1,234
>
>Any helps would be appreciated.
>
>Rob
>
>
>.
>
..

On Thu, 20 May 2004 10:56:32 -0700, "Robert"
<(E-Mail Removed)> wrote:

>Presently in my formula I am using
>
>sngIncr = (Me.TL - Me.MIN) / 17
>
>How should I modify the formula (or what command should I
>use) that would round of the number so no decimals show.

sngIncr = Fix((Me.TL - Me.MIN) / 17)

>Additionally, is there a way that I can round up to the
>nearest number ending in 5. E.g. if the results of mu
>formula is 3072, I would like 3075 to be displayed.

sngIncr = 5*Fix((Me.TL - Me.MIN) / 85)


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public