Thanks Duane, right on. On other forms I had it right but not this one. Again thanks.
Rod
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Rod,
>
> Check the data type of the field. I expect it is numeric long or integer. It should be single, double, or decimal.
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: desertscroller@...
> >
> > I have a field on my form (textbox) that is bound to a field in a table to hold a percent with 4 decimal places. When I enter a value in the form field; i.e. 0.0035 the value is always returned as 0. The format of the form field is general number with 6 decimal places ( have tried 4 places).
> >
> > Trying to use the value to calculate the accrued interest on a bill.
> >
> > Am I missing something?
> > Should I use an unbound textbox then update the table with a query?
> > (Access 2010 on Windows 7)
> > Rod
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar