>Hi Lutz - thanks for the work...
>
>Please note that the whole thing isn't nearly complete, so there is still 'work in progress' untidiness. mTech, and todaysdate are two variables that carry the technicians name, and the date for the report, which will not always be date()
>
>I solved the issue by adding two extra fields to the temp cursor for address1 and address2, instead of a concatenated single address. I keep the single address for the grid on screen, but in the report, I use ad1 and ad2, and put 2 below 1 in the details band. This way even if 2 is empty, the spacing of each report line is the same. This way I can use boxes around everything to give the 'grid line' effect of Excel. I will surely remember the 'fix relative' for anytime I have this kind of hassle again.
>
>Thank you so much for your effort - really appreciated!
>
>Just above this 'subject' is another posting of mine having battles with the calendar on a form - if you would like to chip in, please do!
>
>Best!
>John
for your adress - to keep the line as small as possible try the following
asuming you have field Adress1 and Adress2, Adress two might be empty
now, on the report go to the single line adress field, stretch with overflow and in the expression enter: ALLTRIM(Adress1)+IIF(EMPTY(Adress2),'',0h0D0A+ALLTRIM(Adress2))
This will put adress2 on second line
See the example. It will put additional text (wrong text!) on every even record.
See also the line to create vertical line. Check the properties to see how it's resizing by it's own.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]