"Full" being a relative term, it's probably better to follow the
suggestion offered to show the exact number of items in each list.
You can create a text box next to, or above, each of the list boxes to
display that information. Make it's control source:
=[lstAssociatedListBox].[ListCount]
Obviously, you'll need to change the names from lstAssociatedListBox to
the names of the list boxes in your form.
If you are using Access 2003 or 2003, you can apply conditional
formattting to the textboxes to change the background or foreground colors
if you want to highlight themwhen they have values over a target.
George
Bob Vance said:
OK you caught me out I have 7 list boxes on my Form not all are 6 rows, I
might not remember how many each has , but if I had a "Warning" would
make it so much easier.........Regards Bob
It is a warning that some clients have not paid but as I only have room
to
show 6 on my form , by glancing at it sometimes I don't see there is a
7th.
So hence the warning arrow to show me there is more than
If my list box is full my vertical scroll bar appears! If I had a
label
[lblWarnimg] is it possible to become visible once my list box
becomes
full?
--
Thanks in advance for any help with this......Bob
WindowsXP..MS Access 2007
I guess you could fake it by getting the ListCount and if it's over a
certain number, declare it "full". Doesn't make sense, because you
can scroll a listbox, but anyway...
why not just show the listcount in the tab? for example "Queries (5)"
