Data Validation

[Sixthring]

I have a pop-up list fo data that starts with Please make a selection... I want to make it so that this can not be one of the submited answers. I can not figure out how to return an error when this is not changed to one of the choices in the list. any help would be very appreciated.

[Lee Smith]

Hi 6,

I would use a calculation field in connection with your current field.

For the sake of explanation, lets call your current Field "Value Field" and the new Calculation Field "c_Please Enter"

c_Please Enter, Calculation, Text Result =

Case(IsEmpty( Value Field ), "Please make a selection...")

Note: Make the Calculation field "No Entry" and "No Fill" and put it on top of "Value Field"

HTH

Lee