INCH SYMBOL

  • Thread starter Thread starter ZigZagZak
  • Start date Start date
Z

ZigZagZak

I am using access to automate my shop prints. Obviously there are dimensions
on the prints & I would like to use the inch symbol. I know that access/vba
uses quotation marks for coding purposes, but is there anyway to be able to
use them literally?

Like

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "" O.A.L."

Instead of

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "in. O.A.L."

I don't think its possible.......but you never know with this program. Any
help would be greatly appreciated
 
I am using access to automate my shop prints. Obviously there are dimensions
on the prints & I would like to use the inch symbol. I know that access/vba
uses quotation marks for coding purposes, but is there anyway to be able to
use them literally?

Like

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "" O.A.L."

Instead of

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "in. O.A.L."

I don't think its possible.......but you never know with this program. Any
help would be greatly appreciated
Click to expand...

To enclose a doublequote character in a doublequote delimited string, double
the doublequote (how's that for doubletalk!):

Forms![SCREW IDEA].Form!OAL = Me.OALIN & """ O.A.L."
 
ABSOLUTLY PERFECT!!! Considering I knew about the double && I should have
tried that. But thank you sir! I was getting frustrated by it.

John W. Vinson said:
I am using access to automate my shop prints. Obviously there are dimensions
on the prints & I would like to use the inch symbol. I know that access/vba
uses quotation marks for coding purposes, but is there anyway to be able to
use them literally?

Like

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "" O.A.L."

Instead of

Forms![SCREW IDEA].Form!OAL = Me.OALIN & "in. O.A.L."

I don't think its possible.......but you never know with this program. Any
help would be greatly appreciated
Click to expand...

To enclose a doublequote character in a doublequote delimited string, double
the doublequote (how's that for doubletalk!):

Forms![SCREW IDEA].Form!OAL = Me.OALIN & """ O.A.L."
Click to expand...
 
Back
Top