Check your tables format for that field rather the the form's format for that field???
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of CapitalLease Sent: Friday, October 19, 2007 7:46 AM To: [email protected] Subject: [ms_access] Re: Currency format in a form That was exactly what I thought, but when I do that it doesn't change the value showing in the field, it still rounds it up. I must be approaching this wrong, any other thoughts? --- In [email protected] <mailto:ms_access%40yahoogroups.com> , "rmillson2001" <[EMAIL PROTECTED]> wrote: > > I think you just set the property to give the decimal points. > > --- In [email protected] <mailto:ms_access%40yahoogroups.com> , "CapitalLease" <Capitallease@> > wrote: > > > > I have a field in a form that rounds up currency to the next whole > > dollar. I don't know what I did to make it do that but I need it to > > reflect what I enter without rounding up. How do I correct it? > > > This e-mail and any attachments may be confidential or legally privileged. [Non-text portions of this message have been removed]
