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???