Using the Tan Function
In this tutorial you will learn how to use the Tan Function.
The Tan function returns a Double specifying the tangent of an angle.
=Tan( number )
number any valid number expression that expresses an angle in radians
Tan takes an angle and returns the ratio of two sides of a right triangle. The ratio is the length of the side opposite the angle divided by the length of the side adjacent to the angle.
To convert degrees to radians, multiply degrees by pi/180. To convert radians to degrees, multiply radians by 180/pi.
In this example we will use 1.
The result is 1.5574077246549.
The results using a Query would be
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtTan", then you could add the following in the Load Event.
Private Sub Form_Load()
txtTan = Tan(1)
Access Expert 26
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips