>Thanks for the advice, John.
>
>On the Table side,
>In the table definition I set a default value addnum+" "+prefix+" "+ALLTRIM(addname)+" "+addtype+" "+addapt
>I don't see any 'on save' properties here.
>
>On the form, I tried putting the same formula in the InteractiveChange Event.
>This doesn't do what I expected either.
>
>Can you point me to an example or tell me where I get to 'on save'?
>
>
>>Sounds like a data issue, so the answer depends on how you save data. You should create the old long address from the new data on save.
>>
>>>My client used to have one big 'address field', and now they want in to input/maintain it split up. So they added fields called Streetnum (eg, 11200), Streetname (eg, Main), Streettyp (eg, St.). But, they want to keep the address field for backward-mobility purposes.
>>>
>>>As they type the split-up values, they want to see their old address field get filled in. Should I approach this as a form issue, or something at the database?
>>>
>>>Thanks.
>>>Humble newbie,
>>>Sylvia

A high overhead process is to :
Assign your concatination On your textbox keypress event for each textbox containing sought data and refresh address-field after concat code.
Beware: You will have to capture CHR(13).

Ed B