Number field on form rounds off

J

joe

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
 
A

Alphonse Giambrone

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

Tim Ferguson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top