Display listbox value from checkbox as x for example if the value is -1

[Rino]

Greetings,

Is there someone who could help with following problem?
Currently, the listbox is returning checkbox values either 0 or -1. Is
it possible to instead return values as x if is -1 and nothing if is 0.
Just to display it this way.
Could this be done?

Thank you in advance.

-Rino

 

[Guest]

Hi Rino,

I assume you are talking about a Yes/No datatype. If so, try applying the
following format, in table design view, for this field (F6, after selecting
field):

;"";\X


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Alternatively :-

Assuming the list box is based on a query you could enter the following in
the Field: box in place of your field name :-

XX: IIf([Your Field Name]=True,"X","")

where XX is just a name for the column and 'Your Field Name' is the name of
the Yes/No field.

If you want to show a tick instead of an X you could use the code below -

XX: IIf([Your Field Name]=True,ChrW(8730),"")

assuming that character code 8730 for the font used on the list box is
Square Root character. I don't know of any font that has a proper tick
character.

 

[Rino]

Guys,

thanks to the both of you I made this thing work. I trully appriciate
your help.

Cheers,

-Rino