John Kincaid
asked on
Need to apply a custom number format in Access VBA
Need to apply a custom number format in Access VBA like this:
lngCAN = Format(!CAN, ["18-"0000])
I am getting "Compile error: External name not defined"
The variable "lngCAN" is a number (1,2,3 ...) and the desire is to write "18-0001" and so on.
lngCAN = Format(!CAN, ["18-"0000])
I am getting "Compile error: External name not defined"
The variable "lngCAN" is a number (1,2,3 ...) and the desire is to write "18-0001" and so on.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Great, glad that helped.
»bp
»bp
ASKER