>I don't normally use List Boxes but my predecessor used them extensively. I am trying to stop some strange behavior that is happening. It seems that if you click on this listbox, it will replace the 4-digit employee number with the first four characters of the employee's last name.
>
>I have looked for any method that might be doing this and there is none that I can see. I don't understand how this could be.
>
>Here's what is in the RowSource property:
>
>left(employee.name,10)+" "+employee.employee+":"+empl_mch1.mch+":"+hlpr_mch1.mch
>
>There is an EMPLOYEE table and also a HLPR_MCH (Helper Machine) table. The EMPLOYEE table is related to the HLPR_MCH table through the Employee field, which is actually the 4-digit EMPLOYEE NUMBER, a character data type field.
>
>I looked for a READONLY on the LISTBOX properties, but that doesn't exist, so I disabled it; but then the user can't see what is in the listbox past a certain point, unless they can scroll down. With it disabled, they can't scroll. So, I go round and round.
>
>I need a ListBox expert to help me with this.
>
>My question is this: WHY does the EMPLOYEE NUMBER get replaced with the first 4 characters of the EMPLOYEE NAME?
>
What's the ControlSource? Sounds like it's set to the employee number field.
Tamar