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

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)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:ujRF4Z2DGHA.140@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Frank Martin" <fm@xxxxxxxxxxxxxx> wrote in message
> news:exnibr1DGHA.3468@xxxxxxxxxxxxxxxxxxxxxxx
>> I'm afraid it only 1/2 worked, displaying "No" for all cases.
>> Regards, Frank
>>
>>
>> "Ken Snell (MVP)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
>> news:ueYcGD1DGHA.2704@xxxxxxxxxxxxxxxxxxxxxxx
>>> Pehaps this:
>>>
>>> =IIf(Combo1.Column(1)="+","YES","NO")
>>> --
>>>
>>> Ken Snell
>>> <MS ACCESS MVP>
>>>
>>>
>>>
>>> "Frank Martin" <fm@xxxxxxxxxxxxxx> wrote in message
>>> news:ezT3v70DGHA.516@xxxxxxxxxxxxxxxxxxxxxxx
>>>>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
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>



.

Relevant Pages