Field Calculation

[Jscott]

This might be the wrong place to post this, but I did not see a forum dedicated to calcs.

If Field A is populated and Field B becomes populated, how do I delete the information in Field A?

[mr_vodka]

If field A gets populated first and the clearing of data rests solely on whether a user enters a new value into field B, then you can use a calculated value (with the option for 'Do not replace exiting value' unchecked) for field A with the formula:

Case ( not IsEmpty ( Trim ( B ) ) ; ""; A ).

[Jscott]

notisEmpty doesn't seem to be a proper function?

[Jscott]

Sorry, I forgot to place a space between Not and Is.. Thanks

[mr_vodka]

BTW. just as a FYI. Your post would belong in the 'Define Fields' forum.

[Lee Smith]

I agree, and i moved it.

Lee

[Breezer]

it is a valid function. You will not see it listed as a function on its own but it's the reverse of "IsEmpty" and it is used when you wnat to check if a field is not empty, hence, not IsEmpty.