Bool format in listboxes ...

[H. Martins]

Concerning bool display formats in listboxes, I'm lost.

Some computers show 0/-1, some Yes/No, etc. How do I control what
shows up?

Also, I need to display a listbox column that must show a sort of
compilation of two columns. Say, Condition_A is True/False,
Condition_A_is_valid True False.

I want to display Condition_A only if Condition_A_is_valid is True.
Otherwise displays "" or "?". I suppose I can use 'exp' in queries ...
can't find much about this (and don't know also how to format the
displayed data).

Thanks
Henry

 

[Marshall Barton]

Concerning bool display formats in listboxes, I'm lost.

Some computers show 0/-1, some Yes/No, etc. How do I control what
shows up?

Also, I need to display a listbox column that must show a sort of
compilation of two columns. Say, Condition_A is True/False,
Condition_A_is_valid True False.

I want to display Condition_A only if Condition_A_is_valid is True.
Otherwise displays "" or "?". I suppose I can use 'exp' in queries ...
can't find much about this (and don't know also how to format the
displayed data).

About the only place to do that in the list box's row source
query.

Creating a calculated field and formatting the value is
pretty easy, Just enter something like this in an empty
field cell:

MyFieldName: IIf(Condition_A_is_valid, Condition_A, "?")

Or:

MyOtherField: Format(Condition_A, "Yes", "No")

Or a combination of those.