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@cox.net
>
> 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 (2) |
Tidak ada komentar:
Posting Komentar