Data Validation on a summed Column

[jgabel]

I have done some basic data validation on a form, but I cannot seem to apply data validation to my subtotalled column called SUM FTE.

For the field properties on the Data tab I have the following:

Control Source: =SUM([FTE])
Validation Rule: >1
Validation Text: Total FTE is >1

My test:
Employee A - .50 FTE
Employee A - .60 FTE

SUM: 1.10
Data Validation should indicate SUM FTE >1, but no validation is being reflected on form.

Thank you for any help you can offer.

 

[spikepl]

When stuff "does not work" as expected then the first thing to do is to look it up in the documentation and verify the assumption one has made. Find description of validation for a textbox and read it carefully.

 

[Galaxiom]

Validation is normally used to ensure user input on the control meets the criteria. I doubt that it would be applicable on a calculated control.