By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

date properties

P: n/a
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?

Nov 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.