date properties

[jmarr02s]

I have date fields on a subform

Is there some option under properties for this date field that defaults
data entry into this date field to ensure a value for Month no greater
than 12 is entered or that a value for Number of Days no greater than
31 is entered?

Lastly, is there some option under properties for a date field that
defaults the date entered to change from 13/09/2001 to 9/13/2001? Some
of my date fields on my subform do this and I want to turn this
off/deselect this if it is under properties?

[Rick Brandt]

"jmarr02s" <jo***********@illinois.govwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

>I have date fields on a subform

Is there some option under properties for this date field that defaults
data entry into this date field to ensure a value for Month no greater
than 12 is entered or that a value for Number of Days no greater than
31 is entered?

Are these bound controls? If you bind them to a DateTime field then they are
automatically forced to enter a legal value. Even if unbound all you have to do
is give them a date format and that will force the user to enter a legal date.

Lastly, is there some option under properties for a date field that
defaults the date entered to change from 13/09/2001 to 9/13/2001? Some
of my date fields on my subform do this and I want to turn this
off/deselect this if it is under properties?

The format property controls that. Set it to "m/dd/yyyy".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com