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

fluidmind

Registered User.
Local time
Today, 14:13
Joined
Jun 30, 2006
Messages
66
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
 
fluidmind said:
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.
 
"=" 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
 

Attachments

  • list.jpg
    list.jpg
    20.9 KB · Views: 105
fluidmind said:
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.
 

Attachments

  • query.JPG
    query.JPG
    20.3 KB · Views: 111

Users who are viewing this thread

Back
Top Bottom