Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Are Inch marks possible in a table/form?

Discussion in 'Information Technology' started by lesrat, Jul 28, 2006.

  1. lesrat

    lesrat
    Expand Collapse
    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?
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Fri, 21 Jul 2006 13:06:02 -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.
    >
    > 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
     
  4. lesrat

    lesrat
    Expand Collapse
    Guest

    Thanks! Will try it and see what happens.

    "fredg" wrote:

    > On Fri, 21 Jul 2006 13:06:02 -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.
    > >
    > > 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
    >
     

Share This Page