Is it possible to use the DEC2HEX function in Access's VBA. I want to be able to convert a decimal eg 277 to hex number i.e 115 but make the number 4 digits long. It need to be four digits because its actual the month and day of a date which I need to extract. i,e. 15 of the 1st
I require it to alway be four digits so when I use the Mid function to get the first two characters I get the 01 instead of 11. It also needs to work for 1115 or 15 of the 11th. I can only find the Hex function in VBA and you can't specify the number of digits like you can with the DEC2HEX function.