Decimal Places

Decimal Places. If you add a text box to a form in which you wish to store a general number, but wish not to display a decimal place, what is the best way to set this up?

The default to store a number is General Number, which will automatically display decimal points; even if you set the decimal point property. This is because the General Number format overrides the Decimal Point property. To solve this problem:

Open the property window for the text box (right click on the text box and select properties);

Click on the Format tab;

Then, change Format to either Fixed or Standard (Standard will add a thousand separator to the number).

Then set the Decimal Point property (just below the Format property) to how many decimals you would like displayed.

Hope this is of some benefit to you.