Welcome to SPN

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

Sign Up Now!

Where is the option

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

Tags:
  1. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear friends:

    It seems I cannot type values into text columns in a datasheet without
    Access "correcting" my typing.

    I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    doesn't change it. Another "stupid" feature?

    I turned of the AutoCorrect with which I'm familiar, but that isn't it. So,
    where is this one?

    Thanks for the help.

    Tom Ellison
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    There should be a checkbox labelled "Correct TWo INitial CApitals" that you
    need to uncheck.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    news:%231fAP%23ReGHA.3952@TK2MSFTNGP04.phx.gbl...
    > Dear friends:
    >
    > It seems I cannot type values into text columns in a datasheet without
    > Access "correcting" my typing.
    >
    > I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    > doesn't change it. Another "stupid" feature?
    >
    > I turned of the AutoCorrect with which I'm familiar, but that isn't it.

    So,
    > where is this one?
    >
    > Thanks for the help.
    >
    > Tom Ellison
    >
    >
     
  4. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Doug:

    So, I click on Tools/Steele/Doug/Custom Options and there it is!

    So, if I want to control what goes into a table, maybe I should create a
    form. It won't do that from a form, right?

    I was so hoping I could build all my applications without having to create
    forms and reports. That's hard work!

    Tom Ellison


    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23rdK%23ISeGHA.536@TK2MSFTNGP02.phx.gbl...
    > There should be a checkbox labelled "Correct TWo INitial CApitals" that
    > you
    > need to uncheck.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    > news:%231fAP%23ReGHA.3952@TK2MSFTNGP04.phx.gbl...
    >> Dear friends:
    >>
    >> It seems I cannot type values into text columns in a datasheet without
    >> Access "correcting" my typing.
    >>
    >> I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    >> doesn't change it. Another "stupid" feature?
    >>
    >> I turned of the AutoCorrect with which I'm familiar, but that isn't it.

    > So,
    >> where is this one?
    >>
    >> Thanks for the help.
    >>
    >> Tom Ellison
    >>
    >>

    >
    >
     
  5. Careful with that menu i hear there is an option on there that release a
    monster demon that will take over the world ;)


    --
    ===============================
    Gary Townsend
    Database & Application Developer
    Spatial Mapping Ltd.

    "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    news:OwhSiSSeGHA.1324@TK2MSFTNGP04.phx.gbl...
    > Dear Doug:
    >
    > So, I click on Tools/Steele/Doug/Custom Options and there it is!
    >
    > So, if I want to control what goes into a table, maybe I should create a
    > form. It won't do that from a form, right?
    >
    > I was so hoping I could build all my applications without having to create
    > forms and reports. That's hard work!
    >
    > Tom Ellison
    >
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:%23rdK%23ISeGHA.536@TK2MSFTNGP02.phx.gbl...
    > > There should be a checkbox labelled "Correct TWo INitial CApitals" that
    > > you
    > > need to uncheck.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    > > news:%231fAP%23ReGHA.3952@TK2MSFTNGP04.phx.gbl...
    > >> Dear friends:
    > >>
    > >> It seems I cannot type values into text columns in a datasheet without
    > >> Access "correcting" my typing.
    > >>
    > >> I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    > >> doesn't change it. Another "stupid" feature?
    > >>
    > >> I turned of the AutoCorrect with which I'm familiar, but that isn't it.

    > > So,
    > >> where is this one?
    > >>
    > >> Thanks for the help.
    > >>
    > >> Tom Ellison
    > >>
    > >>

    > >
    > >

    >
    >
     
  6. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    No, unless you turn off Autocorrect, it'll do the same thing in a form.

    That having been said, I believe you should always use a form.

    (It's not obvious from your response, Tom, whether you realized that the
    "Correct TWo INitial CApitals" option I mentioned is on the AutoCorrect
    page)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    news:OwhSiSSeGHA.1324@TK2MSFTNGP04.phx.gbl...
    > Dear Doug:
    >
    > So, I click on Tools/Steele/Doug/Custom Options and there it is!
    >
    > So, if I want to control what goes into a table, maybe I should create a
    > form. It won't do that from a form, right?
    >
    > I was so hoping I could build all my applications without having to create
    > forms and reports. That's hard work!
    >
    > Tom Ellison
    >
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:%23rdK%23ISeGHA.536@TK2MSFTNGP02.phx.gbl...
    >> There should be a checkbox labelled "Correct TWo INitial CApitals" that
    >> you
    >> need to uncheck.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    >> news:%231fAP%23ReGHA.3952@TK2MSFTNGP04.phx.gbl...
    >>> Dear friends:
    >>>
    >>> It seems I cannot type values into text columns in a datasheet without
    >>> Access "correcting" my typing.
    >>>
    >>> I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    >>> doesn't change it. Another "stupid" feature?
    >>>
    >>> I turned of the AutoCorrect with which I'm familiar, but that isn't it.

    >> So,
    >>> where is this one?
    >>>
    >>> Thanks for the help.
    >>>
    >>> Tom Ellison
    >>>
    >>>

    >>
    >>

    >
    >
     
  7. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Doug,

    Yep. Got it now. But where is the "Correct THRee INItial CAPitals" option?

    Tom Ellison


    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:eQyZVETeGHA.4040@TK2MSFTNGP05.phx.gbl...
    > No, unless you turn off Autocorrect, it'll do the same thing in a form.
    >
    > That having been said, I believe you should always use a form.
    >
    > (It's not obvious from your response, Tom, whether you realized that the
    > "Correct TWo INitial CApitals" option I mentioned is on the AutoCorrect
    > page)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    > news:OwhSiSSeGHA.1324@TK2MSFTNGP04.phx.gbl...
    >> Dear Doug:
    >>
    >> So, I click on Tools/Steele/Doug/Custom Options and there it is!
    >>
    >> So, if I want to control what goes into a table, maybe I should create a
    >> form. It won't do that from a form, right?
    >>
    >> I was so hoping I could build all my applications without having to
    >> create forms and reports. That's hard work!
    >>
    >> Tom Ellison
    >>
    >>
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23rdK%23ISeGHA.536@TK2MSFTNGP02.phx.gbl...
    >>> There should be a checkbox labelled "Correct TWo INitial CApitals" that
    >>> you
    >>> need to uncheck.
    >>>
    >>> --
    >>> Doug Steele, Microsoft Access MVP
    >>> http://I.Am/DougSteele
    >>> (no e-mails, please!)
    >>>
    >>>
    >>> "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    >>> news:%231fAP%23ReGHA.3952@TK2MSFTNGP04.phx.gbl...
    >>>> Dear friends:
    >>>>
    >>>> It seems I cannot type values into text columns in a datasheet without
    >>>> Access "correcting" my typing.
    >>>>
    >>>> I type a text value "SCo" but it changes it to "Sco". If I type SCO it
    >>>> doesn't change it. Another "stupid" feature?
    >>>>
    >>>> I turned of the AutoCorrect with which I'm familiar, but that isn't it.
    >>> So,
    >>>> where is this one?
    >>>>
    >>>> Thanks for the help.
    >>>>
    >>>> Tom Ellison
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page