Are Inch marks possible in a table/form?

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13723-are-inch-marks-possible-table-form.html
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?

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Fri, 21 Jul 2006 1302 -0700, lesrat wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13723
> 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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13723

As default field value in a Text datatype field:

"1"""
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks! Will try it and see what happens.

"fredg" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13723

> On Fri, 21 Jul 2006 1302 -0700, lesrat wrote:
>
> > 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13723
> >
> > 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"""
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>