Welcome to SPN

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

Sign Up Now!

Triplestate propery

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

  1. Lijia

    Lijia
    Expand Collapse
    Guest

    I can't get the triplestate property to work in Access. The null value looks
    no different than the no value. In VB it will grey out with the check mark
    visible, in Access it doesn't even grey out (dim) when null is the answer. Is
    the triplestate property available in Access?
     
  2. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Yes, I'm guessing you've got the control bound to a Yes/No (boolean) field,
    you should make the field it is bound to an integer instead.

    --

    Terry Kreft


    "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    > I can't get the triplestate property to work in Access. The null value

    looks
    > no different than the no value. In VB it will grey out with the check mark
    > visible, in Access it doesn't even grey out (dim) when null is the answer.

    Is
    > the triplestate property available in Access?
     
  3. Lijia

    Lijia
    Expand Collapse
    Guest

    It is a interger, long interger to be precise. Any other ideas? I appreciate
    the help.

    "Terry Kreft" wrote:

    > Yes, I'm guessing you've got the control bound to a Yes/No (boolean) field,
    > you should make the field it is bound to an integer instead.
    >
    > --
    >
    > Terry Kreft
    >
    >
    > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    > > I can't get the triplestate property to work in Access. The null value

    > looks
    > > no different than the no value. In VB it will grey out with the check mark
    > > visible, in Access it doesn't even grey out (dim) when null is the answer.

    > Is
    > > the triplestate property available in Access?

    >
    >
    >
     
  4. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    It should work with a long integer (although it's a bit of a waste in
    storage space).

    In Access you should see
    Table Value Display
    -1 Checked
    0 Un-Checked
    Null Un-Checked, Greyed


    I would set these values up in your table and then check the display. If
    the display is wrong then I would check that the checkbox actually is bound
    to the field.


    --

    Terry Kreft


    "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    news:22D33EA0-791C-48AE-9C52-51F3B0C6B775@microsoft.com...
    > It is a interger, long interger to be precise. Any other ideas? I

    appreciate
    > the help.
    >
    > "Terry Kreft" wrote:
    >
    > > Yes, I'm guessing you've got the control bound to a Yes/No (boolean)

    field,
    > > you should make the field it is bound to an integer instead.
    > >
    > > --
    > >
    > > Terry Kreft
    > >
    > >
    > > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > > news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    > > > I can't get the triplestate property to work in Access. The null value

    > > looks
    > > > no different than the no value. In VB it will grey out with the check

    mark
    > > > visible, in Access it doesn't even grey out (dim) when null is the

    answer.
    > > Is
    > > > the triplestate property available in Access?

    > >
    > >
    > >
     
  5. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Erm, looking at your original post again, you have set the tripleState
    property to Ye for the control haven't you? It's on the Data tab of the
    property sheet.


    --

    Terry Kreft


    "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    news:22D33EA0-791C-48AE-9C52-51F3B0C6B775@microsoft.com...
    > It is a interger, long interger to be precise. Any other ideas? I

    appreciate
    > the help.
    >
    > "Terry Kreft" wrote:
    >
    > > Yes, I'm guessing you've got the control bound to a Yes/No (boolean)

    field,
    > > you should make the field it is bound to an integer instead.
    > >
    > > --
    > >
    > > Terry Kreft
    > >
    > >
    > > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > > news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    > > > I can't get the triplestate property to work in Access. The null value

    > > looks
    > > > no different than the no value. In VB it will grey out with the check

    mark
    > > > visible, in Access it doesn't even grey out (dim) when null is the

    answer.
    > > Is
    > > > the triplestate property available in Access?

    > >
    > >
    > >
     
  6. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Lijia, it will work exactly as Terry states, but if you are using Access
    2003 on Windows XP you will not see any visible difference between No and
    Null unless you uncheck the box under:
    Tools | Options | Forms/Reports | Use Windows Themed Controls

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Terry Kreft" <terry.kreft@mps.co.uk> wrote in message
    news:%23K8kI60mGHA.2256@TK2MSFTNGP04.phx.gbl...
    > Erm, looking at your original post again, you have set the tripleState
    > property to Ye for the control haven't you? It's on the Data tab of the
    > property sheet.
    >
    > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > news:22D33EA0-791C-48AE-9C52-51F3B0C6B775@microsoft.com...
    >> It is a interger, long interger to be precise. Any other ideas? I

    > appreciate
    >> the help.
    >>
    >> "Terry Kreft" wrote:
    >>
    >> > Yes, I'm guessing you've got the control bound to a Yes/No (boolean)

    > field,
    >> > you should make the field it is bound to an integer instead.
    >> >
    >> > --
    >> >
    >> > Terry Kreft
    >> >
    >> >
    >> > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    >> > news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    >> > > I can't get the triplestate property to work in Access. The null
    >> > > value
    >> > looks
    >> > > no different than the no value. In VB it will grey out with the check

    > mark
    >> > > visible, in Access it doesn't even grey out (dim) when null is the

    > answer.
    >> > Is
    >> > > the triplestate property available in Access?
     
  7. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Allen,
    Ah, didn't know that one, another reason or me to hate WinXP <g>.

    --

    Terry Kreft


    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
    news:eWORnY1mGHA.2252@TK2MSFTNGP04.phx.gbl...
    > Lijia, it will work exactly as Terry states, but if you are using Access
    > 2003 on Windows XP you will not see any visible difference between No and
    > Null unless you uncheck the box under:
    > Tools | Options | Forms/Reports | Use Windows Themed Controls
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Terry Kreft" <terry.kreft@mps.co.uk> wrote in message
    > news:%23K8kI60mGHA.2256@TK2MSFTNGP04.phx.gbl...
    > > Erm, looking at your original post again, you have set the tripleState
    > > property to Ye for the control haven't you? It's on the Data tab of the
    > > property sheet.
    > >
    > > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > > news:22D33EA0-791C-48AE-9C52-51F3B0C6B775@microsoft.com...
    > >> It is a interger, long interger to be precise. Any other ideas? I

    > > appreciate
    > >> the help.
    > >>
    > >> "Terry Kreft" wrote:
    > >>
    > >> > Yes, I'm guessing you've got the control bound to a Yes/No (boolean)

    > > field,
    > >> > you should make the field it is bound to an integer instead.
    > >> >
    > >> > --
    > >> >
    > >> > Terry Kreft
    > >> >
    > >> >
    > >> > "Lijia" <Lijia@discussions.microsoft.com> wrote in message
    > >> > news:F28010E6-99D2-4410-92DE-ECF21E9ED8C5@microsoft.com...
    > >> > > I can't get the triplestate property to work in Access. The null
    > >> > > value
    > >> > looks
    > >> > > no different than the no value. In VB it will grey out with the

    check
    > > mark
    > >> > > visible, in Access it doesn't even grey out (dim) when null is the

    > > answer.
    > >> > Is
    > >> > > the triplestate property available in Access?

    >
    >
     
  8. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote:

    >Lijia, it will work exactly as Terry states, but if you are using Access
    >2003 on Windows XP you will not see any visible difference between No and
    >Null unless you uncheck the box under:
    > Tools | Options | Forms/Reports | Use Windows Themed Controls


    Ahhhhh!

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page