5 Replies Latest reply: Mar 3, 2013 8:23 AM by Jason Michaelides RSS

    Expression field of list box generates empty value

      I'm using a field expression to generate a combination of first and last name seperated by a comma:

      = [Last Name]  & ', ' & [First Name]


      Strange thing is that, depending on the machine I open the document, sometimes it generates an empty value ( " , ").

      When selecting the empty value, it is all records are shown.


      If I leave out the fixed text ( = [Last Name] & [First Name] ) the empty value is gone.

      Then if I open the same document on a other PC, this empty value is also gone.

      What is causing this effect?

      Is it a usersetting?

      Is it a bug?

      anybody an idea?