Are Inch marks possible in a table/form?

[Guest]

I'm designing a database for a daylilly grower. I want to include a field in
a table that indicates the grown plant height and another for bloom size. I
have tried to insert a default value of 1" in design view, but I get an error
message that says that my expression has an invalid string--I assume because
of the inch (quotation) mark.

I've also tried to do a Lookup Table with different measurements (6" etc),
but the drop-down list includes a semicolon after the inch mark.

Is there a way to include the inch mark (quotation mark) in a field without
triggering an error message or getting extra symbols?

 

[fredg]

I'm designing a database for a daylilly grower. I want to include a field in
a table that indicates the grown plant height and another for bloom size. I
have tried to insert a default value of 1" in design view, but I get an error
message that says that my expression has an invalid string--I assume because
of the inch (quotation) mark.

I've also tried to do a Lookup Table with different measurements (6" etc),
but the drop-down list includes a semicolon after the inch mark.

Is there a way to include the inch mark (quotation mark) in a field without
triggering an error message or getting extra symbols?

As default field value in a Text datatype field:

"1"""

 

[Guest]

Thanks! Will try it and see what happens.

As default field value in a Text datatype field:

"1"""