Auto-enter X when other field has data

[Maxwell Morlay]

I need TixBought field to auto-enter an X if data was entered in Tix2002, Tix2003 and Tix2004.

Thanks for your help.

Maxwell Morlay

[Lee Smith]

Case(

not IsEmpty(Tix2002) , "X",

not IsEmpty(Tix2003) , "X",

not IsEmpty(Tix2004) , "X",

"")

[MoonShadow]

You did use the AND expression. If you only want an 'X' if all three fields are filled in - and they will be filled in at different times, you will need a calculation instead of an Auto-Enter on a standard field. A standard field will not update the value once you have left the record. The calculation would be text with:

Case(not IsEmpty(Tix2002) and not IsEmpty(Tix2003) and not IsEmpty(Tix2004), "X")

Auto-enter on a regular text field will update in vs. 7 if all three fields are filled in at different times if you unclick 'Do not Replace Existing Value..."

[Lee Smith]

Hi Moon,

I read Maxwell's post as an "or" calculation "field" with a result of "X" if data appeared in any of the three fields. I thought that Maxwell meant by "Auto" was he didn't want to enter the "X" manually.

Oh well, now he has more than one way to skin that proverbial cat.

[color:"red"]Without having to upgrade to v7

[Maxwell Morlay]

Thanks, Lee. It works Great!

Maxwell Morlay