Number field on form rounds off

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joe - 09 Aug 2004 15:45 GMT

Hello,

I have a field on my form which will be used for entering dollar amounts but
when a number such as 374.45 is keyed in.....it automatically converts to
round it off to 374.00.This infomation will be used for tracking even the
smallest amount so all data is needed.What do i need to do in properties to
accept the number amounts without it rounding off?
Thanks

Reply to this Message

Alphonse Giambrone - 09 Aug 2004 16:02 GMT

Make sure that the field in the underlying table is defined as currency.

Signature

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us

> Hello,
>
[quoted text clipped - 4 lines]
> accept the number amounts without it rounding off?
> Thanks

Reply to this Message

Tim Ferguson - 09 Aug 2004 17:59 GMT

> when a number such as 374.45 is keyed in.....it automatically converts
> to round it off to 374.00.

Change the field length from Intger or Long to something like Single or
Currency.

HTH

Tim F

Reply to this Message