Triplestate propery

[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?

 

[Terry Kreft]

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.

 

[Guest]

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

 

[Terry Kreft]

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]

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.

 

[Allen Browne]

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

 

[Terry Kreft]

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

 

[Tony Toews]

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