[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index
What is MS Access

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.

 

Do you like this tip? Subscribe to my Newsletter to receive tips via email. Click Here to subscribe.

 

www.simply-access.com (c) 2002 - 2009