Using the CSng Function
In this tutorial you will learn how to use the CSng Function.
The CSng function returns a Single.
=CSng( expression )
expression the value you wish to convert to a Single
When you don't need the precision of a Long.
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtCSng", then you could add the following in the Load Event.
Private Sub Form_Load()
txtCSng = CSng(12.123456789) '12.12346
Access Expert 26
Access Web Sync
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips