8 Replies Latest reply on May 9, 2012 11:36 AM by teachmouse

    Tim with Combo field



      Tim with Combo field


      I have combined a field with other field information, some fields are blank and I end up with leading spaces. I have used the Trim but I get odd results.



      FieldName & " " & FieldType & " " & FieldCode & " "

      Result (FieldName) (FieldType) (FieldCode)

      This is how I am combining the other fields with a space seperation. Some fields have no informaiton so I get the result of

      " " "(FieldCode) or ""(FieldType) (FieldCode)

      If I enter the Trim(CombField) at the end or at the start of the calculation i get dubbles

      (FieldCode)(FieldCode) No space but dubble or tripple of the items being combined.

      Any hope of just having one combo with no space? with out doing a lot of case statements?