FormatNumber function in VBA???

[jgags]

I need to set the length of a variable based on user input in Access VBA. I'm using the function FormatNumber to do that in VB 6.0. The formatnumber function works like this:

FormatNumber(1.1, 5) = 1.100
FormatNumber(2.45, 3) = 2.5
etc.

Is there a similar function in VBA that performs the same task???

[RobDog888]

Access (and all Office VBA) has something similar to NumberFormat
in VB6. Its NumberFormat.

What version of Access are you running? Maybe its an earlier
version that doesnt have it for some reason? But it should be
there in all versions.

[jgags]

I'm running Access 97 and it doesn't work. ??? It's no problem. I found another way to accomplish the same task:

dim numlength as integer
dim numstring as string

do while len(numstr) < numlength
numstring = numstring & "0"
loop

dim thenum as double
thenum = 1.1

thenum = format(thenum, "0." & numstring)

[RobDog888]

Ok, dont have 97 anymore so couldnt test. Only have 2000, 2002,
2003. Its in all of those. You know that having the var as a double, it will not round like the NumberFormat function does?

Option Explicit
 
Private Sub Form_Load()
    Dim thenum As Double
    thenum = 2.45
    thenum = Format(thenum, "0.0000") '=2.4500 and not 2.5000
End Sub