Hi-
I created a report based on queries that the information in it has to be exported to a text file and in turn that text file is being sent to a edi feed. therefore the columns, line spaces, characters etc have to be exactly lined up and matching.
I managed to line most of the fields up but am having some problems with spacing. On one line two fields should be right next to each other with no spaces. If you look at the actual report- everything is overlapped. When saved to the text file it is still 7 spaces away. I can't overlap the text boxes anymore because if i do it cuts off part of the field. i tried combining the fields into one text box like this:
=Trim([Date]) & Space(0) & Trim([ID]) & Space(0) & Trim([Amount])
but i get an error
any advice?
thnx
I created a report based on queries that the information in it has to be exported to a text file and in turn that text file is being sent to a edi feed. therefore the columns, line spaces, characters etc have to be exactly lined up and matching.
I managed to line most of the fields up but am having some problems with spacing. On one line two fields should be right next to each other with no spaces. If you look at the actual report- everything is overlapped. When saved to the text file it is still 7 spaces away. I can't overlap the text boxes anymore because if i do it cuts off part of the field. i tried combining the fields into one text box like this:
=Trim([Date]) & Space(0) & Trim([ID]) & Space(0) & Trim([Amount])
but i get an error
any advice?
thnx
