ndavies

Mmmm.. we want the full address, in one cell, as happens on the one remaining working system without these black dots. These black dots are new to us and seem to wrap data into cells in Excel on export. Are you saying these dots are standard, and to be expected as the norm? It's just that none of our own reports will function in the way they used to anymore because it. AddressLine seems to add a United Kingdom to everything as well, throwing out the label size....still if it means a global replace with blank as a workaround, it might well be the answer. Thanks

When previewing a report, in the AddressBlock field I'm getting two little black vertical lines to delimit the parts of the address. Attached a jpeg to show you what I mean. On export, SIMS or Excel decides to then use these markers to wrap the text into the next cell, which is not how it used to be or what we want. It works fine on one old system (a laptop) but on all other machines with newly installed/upgraded SIMS, these black lines appear. Any ideas? :-( Nick Davies ICT Technician, St Ambrose College