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

[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

 

[Ken Snell \(MVP\)]

Pehaps this:

=IIf(Combo1.Column(1)="+","YES","NO")

 

[Frank Martin]

I'm afraid it only 1/2 worked, displaying "No" for all cases.
Regards, Frank

 

[Ken Snell \(MVP\)]

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.

 

[Frank Martin]

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

 

[Ken Snell \(MVP\)]

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")

 

[Frank Martin]

Thank you, this works fine.
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")