"Tick" result used in a query result (1 Viewer)

Hi - Is it possible to show a tick mark instead of the word "passed"?

I have the character in wingdings font but not sure that can be used in this way?

PassStatus: IIf([status]=0,"X",IIf([status]=1,"Passed","error"))

Thanks

PG:banghead:

you can - but would suggest in a form or report since you cannot specify a specific font for a specific column in datasheet view (query or table)

for the relevant control, specify the wingdings font and modify your passstatus to something like

PassStatus: IIf([status]=0,chr(41),IIf([status]=1,chr(42),chr(48)))

you'll need to check the chr values - and wingdings2 gives more choice.

If status has a value of 0,1 or null, you can also use the control format property to provide colour, and just pass the status value through as a numeric value. As before, set the font type to wingdings2 and your format property will be

[Green]\P;;[Red]\O;[Red]\V

hmmm, ticks are true/false, so remove the IIF.

the checkbox is a table property, or a form property, or report.
if you display the query in a continuous form, you can have the checkboxes.
But a query alone cannot.

That makes sense - thanks very much for your help

Great - thanks for your help

For this I normally use ASCII 251 "√" which appears nice using most fonts.