PublicFunction DecToBin(DeciValue AsLong, Optional NoOfBits AsInteger = 8) _ AsString '******************************************************************************** '* Name : DecToBin '* Date : 2003 '* Author : Alex Etchells '********************************************************************************* Dim i AsInteger 'make sure there are enough bits to contain the number DoWhile DeciValue > (2 ^ NoOfBits) - 1 NoOfBits = NoOfBits + 8 Loop DecToBin = vbNullString 'build the string For i = 0 To (NoOfBits - 1) DecToBin = CStr((DeciValue And 2 ^ i) / 2 ^ i) & DecToBin Next i EndFunction