Share this page:

MS Access: CDbl Function

This MSAccess tutorial explains how to use the Access CDbl function with syntax and examples.

Description

The Microsoft Access CDbl function converts a value to a double.

Syntax

The syntax for the Microsoft Access CDbl function is:

CDbl( expression )

Parameters or Arguments

expression is the value to convert to a double.

Applies To

The CDbl function can be used in the following versions of Microsoft Access:

  • Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

Example (in VBA Code)

The CDbl function can be used in VBA code in Microsoft Access. For example:

Dim LDouble As Double

LDouble = CDbl(8.45 * 0.005 * 0.01)

The variable called LDouble would now contain the value of 0.0004225.