Is it possible to Cond. Format a List box

  • Thread starter Thread starter Bob V
  • Start date Start date
B

Bob V

Is it possible to format a list box , so as if one row has a zero balance is
this field (Part of Script) [tblInvoice_ItMdt.TotalAmount FROM
tblInvoice_ItMdt] I could change the colour of the
font?...............Thanks for any help............Bob
 
Bob,

Access doesn't allow this natively, and I doubt that anyone has come up
with a way to do it with a listbox. As far as I know, the closest you
would get is to make a continuous view subform, and use conditional
formatting on it. You could lay it out so it looks pretty much like a
listbox... but of course if your listbox is multi-select this will be
difficult to mimic with a subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Row Source to Query! 10
Add one field to a script 4
Adding a new column to ListBox! 7
Add one Column to a list box 3
Adding a new column to a List Box! 5
Format List Box! 1
change captions with conditional formatting 2
VBA adding Conditional Format to Range referencing another column value 3

Back
Top