I have a topaz signature pad that I am using with Access that is tied to a sql database. I have modified code to where the signature will pull out when I use a seach combo box. My field is a varchar(8000) and I can pull it out but when I try to pull it out when it is null I get a data type mismatch in Access. So I tried to modify the code to have an If end if to only pull out the data if it is not null but now nothing pulls out. Please help. Here is my combo box code.
[Private Sub Combo241_AfterUpdate()
I modified the code again and as long as the value is not null it will pull the signature out but if it is null it returns a data type mismatch, because the string doesnt recognize the null value. Please help
[ If (AppSign.Value) = Null Then
SigPlus1.SigString = ""
'App sign pull out
SigPlus1.EncryptionMode = 0
SigPlus1.JustifyMode = 5
SigPlus1.JustifyX = 10
SigPlus1.JustifyY = 10
SigPlus1.DisplayPenWidth = 12