CLng
Using the CLng Function
In this tutorial you will learn how to use the CLng Function.
The CLng function returns a Long.
=CLng( expression )
expression the value you wish to convert to a Long
 FORM
In a Form you could set the Default Value of a Textbox to
=CLng(12.1) '12
 VBA
In a Form add a TEXTBOX control and rename it "txtCLng", then you could add the following in the Load Event.
Private Sub Form_Load()
txtCLng = CLng(12.1) '12
End Sub
Course
Access Expert 26
|
Access 328
Seminars
Access SQL 2
|
Access Web Sync
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
