Welcome to SPN

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

Sign Up Now!

Data entry in upper case

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

  1. Lori

    Lori
    Expand Collapse
    Guest

    Is there any way to set the database so that all data entry into my forms is
    upper case? Is there a global way to set this or is it something that needs
    to be set at the form level? Any help is greatly appreciated!

    Thanks
     
  2. Loading...


  3. Sheila D

    Sheila D
    Expand Collapse
    Guest

    You can set the Format property for each (Text) n the table to display as
    Upper Case by using the > symbol. Note that this does not actually convert to
    Upper Case but does display as Upper. By setting it in the table it should
    carry through to each form, report etc. If that's not what you want then set
    the Format property in the individual Form, Reports, etc.
    HTH - Sheila

    "Lori" wrote:

    > Is there any way to set the database so that all data entry into my forms is
    > upper case? Is there a global way to set this or is it something that needs
    > to be set at the form level? Any help is greatly appreciated!
    >
    > Thanks
     
  4. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Sorry - had Insert on - should say
    You can set the Format property for each (Text) FIELD IN the table to
    display as
    Upper Case by using the > symbol. Note that this does not actually convert to
    Upper Case but does display as Upper. By setting it in the table it should
    carry through to each form, report etc. If that's not what you want then set
    the Format property in the individual Form, Reports, etc.
    HTH - Sheila


    "Sheila D" wrote:

    > You can set the Format property for each (Text) n the table to display as
    > Upper Case by using the > symbol. Note that this does not actually convert to
    > Upper Case but does display as Upper. By setting it in the table it should
    > carry through to each form, report etc. If that's not what you want then set
    > the Format property in the individual Form, Reports, etc.
    > HTH - Sheila
    >
    > "Lori" wrote:
    >
    > > Is there any way to set the database so that all data entry into my forms is
    > > upper case? Is there a global way to set this or is it something that needs
    > > to be set at the form level? Any help is greatly appreciated!
    > >
    > > Thanks
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Lori wrote:
    > Is there any way to set the database so that all data entry into my
    > forms is upper case? Is there a global way to set this or is it
    > something that needs to be set at the form level? Any help is
    > greatly appreciated!
    >
    > Thanks


    Got to ask. Why do you want all upper case?

    --
    Joseph Meehan

    Dia duit
     
  6. Lori

    Lori
    Expand Collapse
    Guest

    Thanks for your help - this worked great!

    "Sheila D" wrote:

    > Sorry - had Insert on - should say
    > You can set the Format property for each (Text) FIELD IN the table to
    > display as
    > Upper Case by using the > symbol. Note that this does not actually convert to
    > Upper Case but does display as Upper. By setting it in the table it should
    > carry through to each form, report etc. If that's not what you want then set
    > the Format property in the individual Form, Reports, etc.
    > HTH - Sheila
    >
    >
    > "Sheila D" wrote:
    >
    > > You can set the Format property for each (Text) n the table to display as
    > > Upper Case by using the > symbol. Note that this does not actually convert to
    > > Upper Case but does display as Upper. By setting it in the table it should
    > > carry through to each form, report etc. If that's not what you want then set
    > > the Format property in the individual Form, Reports, etc.
    > > HTH - Sheila
    > >
    > > "Lori" wrote:
    > >
    > > > Is there any way to set the database so that all data entry into my forms is
    > > > upper case? Is there a global way to set this or is it something that needs
    > > > to be set at the form level? Any help is greatly appreciated!
    > > >
    > > > Thanks
     
  7. Lori

    Lori
    Expand Collapse
    Guest

    The people using the database want to ensure that all of their reports are
    uniform and want it all upper case. Not my choice. :)

    "Joseph Meehan" wrote:

    > Lori wrote:
    > > Is there any way to set the database so that all data entry into my
    > > forms is upper case? Is there a global way to set this or is it
    > > something that needs to be set at the form level? Any help is
    > > greatly appreciated!
    > >
    > > Thanks

    >
    > Got to ask. Why do you want all upper case?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  8. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Lori wrote:
    > The people using the database want to ensure that all of their
    > reports are uniform and want it all upper case. Not my choice. :)


    I was afraid of that.

    Lucky for me, I was always in a position to say, sorry, we are not going
    to do that.... and I always got away with it.

    --
    Joseph Meehan

    Dia duit
     

Share This Page