Show Zero as Red and Bold in ListBox (1 Viewer)

[Sebsboutique]

Hi all,

I think i know the answer to this already, but i thought i would ask the clever chap(esse)s in this forum as to whether it could be done.

I have a listbox that displays inventory in my database. I currently have got to the stage where i have the "Inv_Qty" in the listbox showing up as red by converting it to a string in the Query and applying '[Red]@' in the format box for that column.

I wondered if there was a way of ONLY making the Zero Values Red and also making them bold, by applying some sort of fancy Format code in the format part of that Columns Properties?

Thanks in advance,
Seb :0)

 

[Minty]

Have a read of this thread

Is it possible to adjust colors of rows within a listbox?

Hi, the title says it all basically. I'm looking for a way to set background color of individual rows within a listbox, is that achievable? I saw some posts regarding using a ListView instead of ListBox, but those were rather old so i figured that info might be outdated (?)

www.access-programmers.co.uk

for some ideas

 

[CJ_London]

you can create a subform which you can make look like a listbox and use conditional formatting.

Suspect you have already seen it but see this link by @isladogs

Add Query Colour

This explains how to change the colour of individual text/number fields in queries and tables. Similar methods work for comboboxes, listboxes & textboxes in forms

www.isladogs.co.uk

Colour should not be a problem, but bold would be

if you change your 0 to null and use the format

@;[red]"0"

code for 0 to null - probably a more elegant way but try

iif(myfield=0,null,myfield)