I have a list-box in a form (Access 2003) that is displaying records in a table.
That listbox is being correctly filtered and working PERFECTLY (if I might add) :) - It contains a bunch of user names that I have listed as firstname.lastname in the same single cell.
Now, I know I should have made my database with firstname and lastname separated, but it's WAY too late for that, at this point in the game. :)
BUT, due to security reasons, I need to filter the listbox as it's displayed in the form to display ONLY the firstname up to the period, and then first initial of the last name.
Would anybody happen to know the formula I can apply to the code of the list box to make this happen?
Thanks in advance.