Decimal Places displayed

T

Tracy

Registered User.

Local time

Today, 22:42

Joined

Oct 19, 2001

Messages

71

• Feb 4, 2003

• #1

Does anyone know how to specify how many decimal places are displayed for a decimal in a field on a form.

I am currently using the round function

So Round(x / y, 2) This displays x / y rounded to 2 decimal places.

Muy problem is that if x divided by y is an integer (i.e. no decimal places needed), I still want it to show 00 behind the decimal point, but it doesn't.

Anyone know how to fix this.

Thanks
Tracy

 

Mile-O

Back once again...

Local time

Today, 22:42

Joined

Dec 10, 2002

Messages

11,316

• Feb 4, 2003

• #2

Use the DecimalPlaces property of your controls to set it to the number of decimal places you wish - you can have from 0 to 15 decimal places.

 

T

Tracy

Registered User.

Local time

Today, 22:42

Joined

Oct 19, 2001

Messages

71

• Feb 4, 2003

• #3

Thanks for the tip, but if the last decimal place is a 0 this doesn't work. So, for example, 15.00 will still display as 15, 15.30 will display as 15.3

Any other ideas?

 

Mile-O

Back once again...

Local time

Today, 22:42

Joined

Dec 10, 2002

Messages

11,316

• Feb 4, 2003

• #4

You can set the format of the control.

I think 0.00 will work.

 

T

Tracy

Registered User.

Local time

Today, 22:42

Joined

Oct 19, 2001

Messages

71

• Feb 4, 2003

• #5

Still no luck. Can't set the format to 0.00. I tried setting it to fixed with 2 decimal spaces but it just won't display them. I'm completely out of ideas here. Sure there must be a way.

 

neileg

AWF VIP

Local time

Today, 22:42

Joined

Dec 4, 2002

Messages

5,975

• Feb 4, 2003

• #6

Fixed with two decimals works for me.

If you are applying any formatting in the table or query, take this out and rely on the formatting for the control on the form.

 

T

Tracy

Registered User.

Local time

Today, 22:42

Joined

Oct 19, 2001

Messages

71

• Feb 4, 2003

• #7

Yeah, sorry, I'm being a div, it works fine.

Thanks