Originally Posted by hvelador

Hello everyone, I have an Access question.

I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered.

What expression can I input into the "Validation Rule" field in the "Field Properties" section of the Design View page so that the rule doesn't allow data unless it is mm/dd/yyyy hh:mm am/pm? The users are entering one part or another, but not both, and I would like to prevent that. I have seen validation rules for date or time, but not both.

Suggestions are welcome.

Thanks again,

Regards,

Horacio