Douglas J. Steele said:
No, as I already said, there isn't such function built into Access.
However, it's fairly easy to write your own function.
You can use Asc to convert the symbol to decimal.
You can use Hex to convert the decimal representation to hex.
You can write a function to convert the hex to binary.
Something along the lines of:
Function CharBinary(Character As String) As String
Dim intLoop As Integer
Dim strInBinary As String
Dim strInHex As String
strInBinary = vbNullString
strInHex = Hex(Asc(Character))
For intLoop = 1 To Len(strInHex)
Select Case Mid(strInHex, intLoop, 1)
Case "0"
strInBinary = strInBinary & "0000"
Case "1"
strInBinary = strInBinary & "0001"
Case "2"
strInBinary = strInBinary & "0010"
Case "3"
strInBinary = strInBinary & "0011"
Case "4"
strInBinary = strInBinary & "0100"
Case "5"
strInBinary = strInBinary & "0101"
Case "6"
strInBinary = strInBinary & "0110"
Case "7"
strInBinary = strInBinary & "0111"
Case "8"
strInBinary = strInBinary & "1000"
Case "9"
strInBinary = strInBinary & "1001"
Case "A"
strInBinary = strInBinary & "1010"
Case "B"
strInBinary = strInBinary & "1011"
Case "C"
strInBinary = strInBinary & "1100"
Case "D"
strInBinary = strInBinary & "1101"
Case "E"
strInBinary = strInBinary & "1110"
Case "F"
strInBinary = strInBinary & "1111"
Case Else
End Select
Next intLoop
CharBinary = strInBinary
End Function
Now, CharBinary("A") will return "01000001"
I'll leave writing the inverse to you.