How to not show "Yes" or "No" in list-box

[fluidmind]

Hi there!

I have a yes/no column in my table, that I want to show in a form. But instead of showing "yes" or "no" in my listbox in the form I want to show "X" or "" (blank).

How is that done???

Regards John

 

[MaliciousMike]

Hi there!

I have a yes/no column in my table, that I want to show in a form. But instead of showing "yes" or "no" in my listbox in the form I want to show "X" or "" (blank).

How is that done???

Regards John

Best bet would be to create a query and have the expression:

Expr1: IIf([Column]="Yes","X",Null)

Then use the query as the source for the listbox.

I hope i've understood correctly.

 

[fluidmind]

"=" expected

Hi Malicious Mike!

Thanks very much for your help... As you've probably figured out, I'm very new to this stuff, so that's why I'm asking you to go a little bit more in depth!

It seems like you understand my question correctly. No problem. And I see the way you want it to work, I didn't think of using that command myself. But when I try just to write it into the source for the listbox it returns with a "= expected".

I've attached a screenshot of my list. I want the "3" and the "C" column to be either "X" or "". My source for the listbox is:

SELECT sælgerdata.sælgernr, sælgerdata.fornavn, sælgerdata.efternavn, sælgerdata.tlf1, sælgerdata.email, sælgerdata.senestecoaching, sælgerdata.kursus3akut, sælgerdata.coachingakut FROM sælgerdata WHERE [erhverv]=0 And [aktiv]=-1 ORDER BY [fornavn];

Hope you or another one can help me fix my source ;-)

// JR

 

[MaliciousMike]

Hi Malicious Mike!
SELECT sælgerdata.sælgernr, sælgerdata.fornavn, sælgerdata.efternavn, sælgerdata.tlf1, sælgerdata.email, sælgerdata.senestecoaching, sælgerdata.kursus3akut, sælgerdata.coachingakut FROM sælgerdata WHERE [erhverv]=0 And [aktiv]=-1 ORDER BY [fornavn];

Hope you or another one can help me fix my source ;-)

// JR

Create a query.
Put all those fields inside it including the filters (WHERE...)
you can order [fornavn] from the query.

In the query columns for "3" and "C" put that code in where field is.

Hope this screeny describes that in visual detail.

When that's created and working, set the record source to that query and go from there.

 

[fluidmind]

Thanx

You are the man!!!!

Thank you!

 

[MaliciousMike]

You are the man!!!!

Thank you!

glad to help