# Make A Textbox Always Display 2 Decimal Digits.

Views: 22

The properties of the text box that seem relevant are set to:

Format, currency

Decimal places, 2

visible, yes

Control source, =" " & [SqM]*Forms!frmControlPanel!frmSubOptions.Form!boxCleansingCost

Input mask, blank

running sum, no

And of course the computer is set to English UK. Yes, the one that spells properly! All those stray z's. argh

Sponsored Links:

Thank you for taking the time to report an issue.

What's wrong... Please write below.

## More topics

### Rounding to 2 decimal places

If I add 0.005 I will get the correct value for this, but if I get an answer of say 100.3848 and I round it after adding the .005, my answer is wrong.

My problem would be solved if I could test the number of digits after teh decimal place.

using the right(Cinput, 1) function to test the last decimal, it returns either the 2nd, 3rd or 4th digits depending on how many decimal places there are.

### Stop text box from rounding decimals

The problem is that whenever you enter a number with more than 2 decimals the textbox rounds the second decimal place up or down which I don't want. I just want to drop off any decimals greater than 2.

For instance if I enter 12.225 in a textbox the value displayed is rounded up to 12.23 and I want it to display 12.22 and ignore the third decimal.

I tried an input mask and that works but is not ideal for my purpose

### Number conversion

For example, 153.15 should become 0015315. I can only get it as far as being 15315. Is there a way I can set Properties to format this field, or is there another expression I can add to my calculation? I'm multiplying the source field by 100 to get rid of the decimal.

Any help will be appreciated as I'm stuck on this step.

### label and currency textbox

How can I make the last character of the label line up with the last decimal of a currency value?

### Converting COBOL picture format number to regular decimal number using SQL

COBOL Picture

9(09)v9(06)

so the number would be 000009059790000

and the conversion would be 6 digits to the right of decimal and 9 digits to the left. so the output I would want is 9059.79

I was doing the following but its displaying the 0's in front and I didnt want that.so I am getting 000009059.790000

LEFT(Income, 9) + '.' + RIGHT(Income

### Limiting decimal places

### Rounded number inside of text

Basically I want a control box that has a control source of

="(TRIM GIRTH= " & [Trim Girth] & ")"

Is there a way for me to make it round it to the nearest three while still in the query?

### Formatting currency with the cents but without the decimal point

I should also mention that this is an Access 97 db that has to be totally redone at some point in a later version. It won't convert to any higher a version because there is a lot of code in it that goes back to either Access2 or Access 95.

### displaying the time 12:00:00 AM

it seems to be there because I can use datediff and my formula works but cant make it display

### Numbers look right on the form, report shows #####

However, I'm trying to print a report from that form and subform. Of course, we're back to the same problem. I need to see a report AND a subreport that display the same calculations, and I seem to be right back where I started.

On my subreport, the numbers that appeared on the form are back to displaying ####### instead of a few digits with two decimal places.