Default Value

[BBryan]

Hi,
In my table I want to put a default value of 1/4". Is there a way to do this I have tried "1/4"", '1/4"'. It seems it will not let me use the " symbol for inches.


Thanks Bryyan

 

[Uncle Gizmo]

Try:

"1/4" & Chr(34)

 

[BBryan]

Thanks
That is exactly what I was looking to do. I would have never thought to use this.

Bryyan

 

[gemma-the-husky]

out of interest, you normally get a " character by including it twice

so maybe 1/4"" would have worked?!

 

[BBryan]

Hi,
I tried that and I recieved a Message error invalid string

Thanks

 

[gemma-the-husky]

ah

maybe something like

"1/4""" then. (with 3 " at the end)

you may be able to use single quotes as well

'1/4"' (its a single quote at the end)

having said that, in general, i prefer to do what uncle gizmo said, and use chr(34) when i need to concatenate a " character.

 

[Uncle Gizmo]

This "may" work "1/4"""

But this "1/4" & Chr(34) is easier to read, to "know" (you know it's right) once you get the gist of how it works.

In other words it satisfies the “readability” target, the clarity of what it means is written within itself, once you understand it it is self explanatory.

Unless of course you forget which character is character 34, I very often get muddled up with character 42!