Date/Time Entry Validations

[midge]

Hi

I am new to using Microsft Access 2000 and am experiencing problems using entry validations:-

1. Field Name Visit Date - entries only accepts current year e.g. 2003

2. Field Name Visit Time - only accepts times between 09:00 - 18:00.

3. Field Name Contact Name - First Character of Christian Name and Surname must be a Capital. All the other characters must be lower case.

Thanks for your help to solve my problems.

Regards,

Midge

 

[Mile-O]

1. =Year(Date())

2. Between Timeserial(9,0,0) And TimeSerial(18,0,0)

3. Redesign your database to have fields called ContactForename and ContactSurname - it's easier.