Bool format in listboxes ...

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

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
 
H. Martins said:
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).
Click to expand...

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.
 
Back
Top