B
Bob Vance
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?
[lblWarnimg] is it possible to become visible once my list box becomes full?
P
pietlinden
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...
B
Bob Vance
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
6..............Regards Bob
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...
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
6..............Regards Bob
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...
P
pietlinden
why not just show the listcount in the tab? for example "Queries (5)"
B
Bob Vance
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
might not remember how many each has , but if I had a "Warning" would make
it so much easier.........Regards Bob
A
a a r o n . k e m p f
yah dude are you designing an app for handicapped people or
something?
something?
G
George
"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
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:
B
Bob Vance
Why would you like one! 
message
yah dude are you designing an app for handicapped people or
something?
message
yah dude are you designing an app for handicapped people or
something?
B
Bob Vance
Thanks George sounds a great idea I will do it that way , just to give
warning there are more records in the list box.........Thanks Bob
warning there are more records in the list box.........Thanks Bob
George said: