I need to convert +/- to true/fasle.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have a chart for displaying ledger accounts and I need a text box on the
form to indicate if the ledger account contains taxed items or not.

The combo I use for selecting the accounts has this information, but only in
the +/- format, and when I display this on the main form with
"=Combo1.Column(1)" all I get is the +/-, whereas what I really need is
YES/NO.

How do I force the main-form text box to show YES/NO instead of +/- .
Adjusting the format property does not seem to work.

Please help, Frank
 
Then you must have something other than "+" sign in the second column of the
combo box.

Note: Column is a zero-based property for a combo box (and a list box).
Thus, the first column is number 0, the second column is number 1, etc.
 
All I can get from the Combo is a column of check boxes some of which
are ticked.

Even when I go back to the relevant table there are only three options
given:

1/ Yes/No
2/ On/Off
3/ True/False

There is no "+/-" enywhere, not even in the form's 'properties'.

Regards, Frank
 
From your description, the field that is being displayed in the combo box is
a Boolean field, which has a value of -1 for True (or Yes or On), and a
value of 0 for False (or No or Off).

So, let's revise your expression to this:

=IIf(Combo1.Column(1)=True,"YES","NO")
 
Thank you, this works fine.
Regards Frank

Ken Snell (MVP) said:
From your description, the field that is being displayed in the combo box
is a Boolean field, which has a value of -1 for True (or Yes or On), and a
value of 0 for False (or No or Off).

So, let's revise your expression to this:

=IIf(Combo1.Column(1)=True,"YES","NO")
Click to expand...
 
Back
Top