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?

Like I said, there are no METHODS, no CLICK EVENT, nothing to do this behavior, yet it happens each time you click on the LISTBOX.