Giving the user a choice in the date field...

[rhodesmk]

I'm building a membership directory database. I want birth dates and
anniversary dates, but, being the fickle folks some are, I want those who are
proud of their age to be able to enter month, day, and year, and those who
are a bit more private to be able to enter month and day only, leaving the
year blank. Yes, this could be a free form text field, but I'd rather it be
a time/date field so I can run reports that will let me know who gets
birthday/anniversay notices in our church newsletter.

Thanks!

 

[tina]

a date/time field will store a complete date, no exceptions. if you don't
enter a year, i believe the date will default to current year. for data
entry / display purposes, you can format the form/report control to show
only the month and day. with a bit more work, using VBA code, you should be
able to display complete dates for those members with "real" dates, and
month/day for the others - if your members are all adults, some reasonable
time frame cutoff should work, at least for the next 17 years or so.

hth

 

[rhodesmk]

Thanks. This makes perfect sense.

Michael

 

[rhodesmk]

Thanks. This makes perfect sense.

Michael

a date/time field will store a complete date, no exceptions. if you don't
enter a year, i believe the date will default to current year. for data
entry / display purposes, you can format the form/report control to show
only the month and day. with a bit more work, using VBA code, you should be
able to display complete dates for those members with "real" dates, and
month/day for the others - if your members are all adults, some reasonable
time frame cutoff should work, at least for the next 17 years or so.

hth

 

[rhodesmk]

Worth checking in to. Thanks for the info.

Michael

 

[tina]

you're welcome

Thanks. This makes perfect sense.

Michael