Welcome to SPN

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

Sign Up Now!

Caps Lock

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

Tags:
  1. Confused Slug

    Confused Slug
    Expand Collapse
    Guest

    It is possible to set Caps Lock on when opening a database?

    I have formated the fields and table etc to show all caps but when you edit
    the data in a field (where the data was initially entered in lower case) the
    text reverts to lower case during the edit phase.
     
  2. Loading...

    Similar Threads Forum Date
    India 35 feared drowned as boat capsizes in north India Breaking News Jun 15, 2010
    Debate With Sarbjeet Singh Dhunda At Turlock (California) Gurdwara, April 2015 - YouTube Gurmat Vichaar Apr 23, 2016
    Uk clocks go back Blogs Oct 17, 2015
    Kesh: Dreadlocks Questions and Answers Nov 20, 2013
    Obamacare Faces Near-Solid Block In The South Health & Nutrition Mar 31, 2013

  3. Jon Lewis

    Jon Lewis
    Expand Collapse
    Guest

    Try suing the UCase function to convert the input to upper case.

    e.g.

    Private Sub MyTextBox_AfterUpdate()
    Me.MyTextBox = UCase(Me.MyTextBox)
    End Sub

    The data will then be stored in upper case. Formatting controls how data is
    displayed rather than how it is stored.

    HTH

    "Confused Slug" <ConfusedSlug@discussions.microsoft.com> wrote in message
    news:B7E7D1A1-6DA5-4251-AF26-38C0EA05110D@microsoft.com...
    > It is possible to set Caps Lock on when opening a database?
    >
    > I have formated the fields and table etc to show all caps but when you
    > edit
    > the data in a field (where the data was initially entered in lower case)
    > the
    > text reverts to lower case during the edit phase.
     
  4. Confused Slug

    Confused Slug
    Expand Collapse
    Guest

    Thanks

    "Jon Lewis" wrote:

    > Try suing the UCase function to convert the input to upper case.
    >
    > e.g.
    >
    > Private Sub MyTextBox_AfterUpdate()
    > Me.MyTextBox = UCase(Me.MyTextBox)
    > End Sub
    >
    > The data will then be stored in upper case. Formatting controls how data is
    > displayed rather than how it is stored.
    >
    > HTH
    >
    > "Confused Slug" <ConfusedSlug@discussions.microsoft.com> wrote in message
    > news:B7E7D1A1-6DA5-4251-AF26-38C0EA05110D@microsoft.com...
    > > It is possible to set Caps Lock on when opening a database?
    > >
    > > I have formated the fields and table etc to show all caps but when you
    > > edit
    > > the data in a field (where the data was initially entered in lower case)
    > > the
    > > text reverts to lower case during the edit phase.

    >
    >
    >
     

Share This Page