I have a calculated control using the following code:
I tried doing both """"(4) and """""(5) but neither work. They then give me a type error.Code:Right([length],1=""")
I am trying to get it to detect if the last character is a double quote. Ex: 62"
full code:
(basically if theres a double quote then zls and if there is no double quote at the end then add a single quote signifying it is in feet.)Code:=[Quantity] & "' X " & [Length] & IIf(Right([length],1="""),"","'")