Custom Text based on field value

[tri.stand]

Morning all,



I'm not very good with Access and certainly have no idea about VBA.
I am just messing about with importing data from Excel to Access and then displaying it in a Report. So far, I've muddled my way through and learnt a few bits.

My next target is to have a field/textbox within my Report display a text output based on the look up value in my table.

I'm trying to lookup TINSPASS which displays one of the following values: -1, 0, 1
And I would like to to display the following text against each value in my report: -1 = "PASS", 0 = "" (Empty Textbox), 1 = "FAIL"

Any help would be gratefully received.


PS: Using Office 365

[CJ_London]

Use a combo box with a value list rowsource of

-1;”pass”;1;”fail”
Set column count to 2
Set column width to 0
Set controlsource to [tinspass]

[tri.stand]

Thanks @Ajax, I've tried this, but I think i'm missing something as it is displaying the samething (-1, 0, 1)

I've attached the file

[CJ_London]

away from my computer - but sounds like you have not done this part

Set column width to 0

columnwidth is not the same as width (which refers to the control, not the column)

[Welshgasman]

Look at how it is done.

[tri.stand]

Thank You Ajax & Welshgasman!!

All starting to make sense now. I had "Row Source Type" still set as "Table/Query", changed to "Value List" and problem solved.

Thank you so much!!!

[Micron]

display a text output based on the look up value in my table

If that means the table field is a lookup field, then while you'll see "Smith" the actual value is a number that's in a hidden table. Might have been the real issue? Might continue to be an issue as well.

[accesstos]

I would like to to display the following text against each value in my report: -1 = "PASS", 0 = "" (Empty Textbox), 1 = "FAIL"

Just set the TINSPASS's Format property to: "Fail";"Pass";""

[mike60smart]

Hi
You will need to change the design of your database.

You currently have 1 table which is dealing with PQT Testing of various appliances.

You will need to look at normalising your table.

A Customer has a property that needs Testing on an Annual basis.

This means you need multiple tables and not just 1

[Welshgasman]

Very nice

Just set the TINSPASS's Format property to: "Fail";"Pass";""

[CJ_London]

Forgotten about the format method.

to add a bit of colour [Red]"Fail";[Green]"Pass";""

Only issue would be if user wants to change the value - the underlying value will show so it can be edited. Tho' this being a report, should not be happening