Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Access    Excel    Word    Windows    HTML

# Int

## Using the Int Function

In this tutorial you will learn how to use the Int Function.

The Int function returns the integer portion of a number.

=Int( number )

number any valid number expression

Int returns the first negative integer less than or equal to number. For example, Int converts -8.4 to -9

In this example we will use 99.8.

The result is 99.

Query

The results using a Query would be

```	SELECT Int(99.8);
```

FORM

In a Form you could set the Default Value of a Textbox to

```	=Int(99.8)
```
VBA

In a Form add a TEXTBOX control and rename it "txtInt", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtInt = Int(99.8)
End Sub
```

Courses Tips

See this FREE Tip on Int, Round and Fix.

Search

 Check out these other pages that may be of interest to you:
 5/26/2023 Hide With Macro 5/25/2023 Calculator 6 5/24/2023 Object Size Analyzer 5/24/2023 Calculator 5 5/23/2023 Plural 5/22/2023 Calculator 4 5/19/2023 Calculator 3 5/18/2023 Calculator 2 5/17/2023 Calculator 5/16/2023 Variable Default