A calculation field:
Substitute ( List ( House name ; Town ; Postcode ) ; ¶ ; ", " )
gives always the correct result, even if a field is empty.
Placing that field in the Layout ( instead of the merge field ) solves also the second problem.
Perfect - will test out now - thank you
i have got the newvfield working perfectly, but i cannot enter data in it to find when in find mode...assume because it is a calculated result? any suggestion?
You should be able to enter search criteria into a calculation field when in find mode, but not if you've added it to your layout as a <<merge field>>.
If you have not added it as a merge field, use the inspector to check Field Behavior settings to make sure that access to the field is permitted when in browse find mode.
I can enter search criteria - its just that FM cannot find any records although I know that some fields do contain the search criteria that i have entered...
Is the calculation field set to return "text" or "number" as its return type? What you describe could indicate that it is set to return number instead of text. There's a drop down list inside the specify calculation dialog where you make this selection for a calculation field.
That was it! Doh...