Welcome to SPN

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

Sign Up Now!

Re: capitals

Discussion in 'Information Technology' started by Barry S F, Jul 28, 2006.

Tags:
  1. Barry S F

    Barry S F
    Expand Collapse
    Guest

    Jeff, thanks for the question. I'm pulling the info from my table which is
    using
    the " > " in the format and also in my form that is using the query in a
    List box. I don't remember seeing that in the help files. I'll try it and let
    you know.

    "Jeff Boyce" wrote:

    > You don't say how you have the query capitalizing.
    >
    > Are you using the UCase() function?
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    >
    >
     
  2. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Barry

    What is stored, and how it is displayed are two different issues.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "Barry S F" <BarrySF@discussions.microsoft.com> wrote in message
    news:35707A73-4843-40E7-9B7A-C71E8ABEE7A8@microsoft.com...
    > Jeff, thanks for the question. I'm pulling the info from my table which is
    > using
    > the " > " in the format and also in my form that is using the query in a
    > List box. I don't remember seeing that in the help files. I'll try it and
    > let
    > you know.
    >
    > "Jeff Boyce" wrote:
    >
    >> You don't say how you have the query capitalizing.
    >>
    >> Are you using the UCase() function?
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >>
    >>
     
  3. Barry S F

    Barry S F
    Expand Collapse
    Guest

    I've tried to use the UCase() and tried it in several places. I can't find it
    in the help index, so I moved it around from code in the list box to the
    table and queries. Also tried "Upper" and that didn't help me either.
    Currently I have: Table(caps) > Query(caps) > Listbox (mix of upper and lower
    case).
    Example: Table: B1234, Query: B1234 and ListBox: b1234.
     

Share This Page