I manage a small Fpro dbase for a nonprofit, and am have created fields to that "calculate" other fields so that, for instance, the address field will be one text field containing address&city&state&zip. I can set up and execute this script, no problem. However, my client does not want to click a button to perform the script, but rather wishes to have it force update through tabbing into a field, or some other hidden method.

Suggestions? Solutions? Funky work-arounds? I could use some help urgently. Thanks!

Set up a calculation field whose output type is text:

cAddress= addressfield & cityfield & ", " & state &" " & zip

This will put everything on 1 line. If you want a multi-line concatenated address, just insert after each field to create new line(s).

There is no need for a script.

Steve