|
|
||||||
|
#1
08-21-08, 09:55 PM
|
|
|
|
|
Re: Access 2003
I have a textbox for Debit and Credit amounts. Right now I can enter $45.78888 and when I tab to the next field the amount becomes $45.79. The actual amount should be $45.78. These columns in the table are set to 2 decimal places, which I though would have fixed this. So I thought I would set up an edit mask. Thi swon't work as to set an Edit mask, they can only be for Text and Date fields, not numeric fields. How do I modify these two text boxes to where when the 2 numbers to the right of the decimal are entered, no more data can be entered into the text box? Thanks. |
|
|
|
#2
08-21-08, 10:29 PM
|
|
|
|
|
It sounds like Access is following the "rounding rule" I learned in
elementary school. Are you saying that you'd want $45.789999 to also be $45.78? Take a look at the underlying properties of the textboxes (or the underlying fields' properties). If you set the format to "Currency" and limit it to 2 decimal places, does that do what you want? More info, please. Regards Jeff Boyce Microsoft Office/Access MVP "RLN" <RLN> wrote in message news:dcd8 [..] |
|
#3
08-21-08, 10:31 PM
|
|
|
|
|
Use input mask -- #.## and it will not allow more than two digits
following decimal. |
|
#4
08-22-08, 05:22 PM
|
|
|
|
|
Jeff,
Right now the user can enter "$45.7867890". When they tab to the next field, this value changes and shows on screen "$45.79". I need to only allow them to enter 2 digits to the right of the decimal. Anything past that should be cancelled and not shown and the value should remain at $45.78. Hope this clarifies. |
|
#5
08-22-08, 06:18 PM
|
|
|
|
|
I got it to work. I set the Edit Mask to "###,###,###.##", set decimal
places to 2. I don't suppose I need to have Decimal places set to 2 since the edit mask is in place. Thanks for the assistance here, I appreciate it. RLN |
|
|
| Similar Threads | |
| Editing 1099 Amounts I've done this before, but can't remember how...I know it's simple. Where do I go to edit $ amounts on 1099's prior to printing them? |
|
| Editing 1099 amounts using Initialize Mode We have a vendor that had both reportable and non-reportable payments this year. Consequently the amount reflected in box 7 is higher than it should be. I know I can adjust... |
|
| Formatting monetary amounts with currency indicator on extreme left and amount right ? can this be done so that cells look something like this; $ 1200.03 $ 120.88 Any help much appreciated. Thanks |
|
| 11 $ amounts, 6 of the amounts must equal $3854.12, which 6? I have 11 deposit items and 6 of them equal $3854.12 but how do I find out which 6 deposits equal the $3854.12. Thanks for your help. |
|
| Editing Vendor 1099 Amounts in 8.0 Last time I filed 1099's in GP, it was version 6.0 and we could not edit any amounts. We ended up buying an off- the-shelf 1099 package (we e-filed too, so GP wouldn't have... |
|
|
All times are GMT. The time now is 04:54 AM. | Privacy Policy
|
Editing monetary amounts