List box Full warning!

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
"George" <george_hepworth DeleteThis @hotmail.com> wrote in message
news:831A01A2-10AB-42CC-BDE0-9CD0CCC14B25@microsoft.com...
> "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" <rjvance DeleteThis @ihug.co.nz> wrote in message
> news:%23mssawa3IHA.4036@TK2MSFTNGP02.phx.gbl...
>> 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
>> <pietlinden DeleteThis @hotmail.com> wrote in message
>> news:1dc9ce78-ae29-41b0-9786-e497a0b3c0c6@m45g2000hsb.googlegroups.com...
>>> On Jul 3, 9:33 pm, "Bob Vance" <rjva... DeleteThis @ihug.co.nz> wrote:
>>>> 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<pietlin... DeleteThis @hotmail.com> wrote in message
>>>>
>>>> news:fc4323ce-4bbf-4105-8e7a-a772e15b3c20@56g2000hsm.googlegroups.com...
>>>> On Jul 3, 8:07 pm, "Bob Vance" <rjva... DeleteThis @ihug.co.nz> wrote:
>>>>
>>>> > 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)"
>>
>>
>