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

Custom Input Mask

P: n/a
Hello, and thank you in advance for your help. Again.

I want to enter the month and day portions only of a date into a table
field. The idea is that I'll use the information later to generate a list of
birthdays by using a query (all the birthdays in January, all in February
and so forth). The organization doesn't ask for dates of birth - the only
information available is the day and month - 8/4, for example is my birthday
and that's all that would be entered in the table.

I've fiddled with this a good deal and it seems that no matter what the
input mask, Access wants to put the current year into the field as well. I'm
concerned that this will somehow cause a problem in the future, I just don't
know how.

Is it possible to enter just the month and date using an input mask, or does
this have to be done as text, with the attendant problem of ordering the
birthdays in date order, since the sort then seems to be done only on the
characters before (to the left of) the "/" character...

Thanks.
Steve E.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Include the DOB and Birthday fields in your table. On your data entry form,
include both fields. Make DOB visible and Birthday not visible. Put the
following code in the AfterUpdate event of DOB:
Me!Birthday = Format(Month(DOB),"00") & "/" & Format(Day(DOB),"00")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Serious_Practitioner" <Se************************@att.net> wrote in message
news:ti********************@bgtnsc05-news.ops.worldnet.att.net...
Hello, and thank you in advance for your help. Again.

I want to enter the month and day portions only of a date into a table
field. The idea is that I'll use the information later to generate a list of birthdays by using a query (all the birthdays in January, all in February
and so forth). The organization doesn't ask for dates of birth - the only
information available is the day and month - 8/4, for example is my birthday and that's all that would be entered in the table.

I've fiddled with this a good deal and it seems that no matter what the
input mask, Access wants to put the current year into the field as well. I'm concerned that this will somehow cause a problem in the future, I just don't know how.

Is it possible to enter just the month and date using an input mask, or does this have to be done as text, with the attendant problem of ordering the
birthdays in date order, since the sort then seems to be done only on the
characters before (to the left of) the "/" character...

Thanks.
Steve E.


Nov 13 '05 #2

P: n/a
Thank you...that works just fine!
Steve E.


"PC Datasheet" <no****@nospam.spam> wrote in message
news:nv*****************@newsread3.news.atl.earthl ink.net...
Include the DOB and Birthday fields in your table. On your data entry form, include both fields. Make DOB visible and Birthday not visible. Put the
following code in the AfterUpdate event of DOB:
Me!Birthday = Format(Month(DOB),"00") & "/" & Format(Day(DOB),"00")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Serious_Practitioner" <Se************************@att.net> wrote in message news:ti********************@bgtnsc05-news.ops.worldnet.att.net...
Hello, and thank you in advance for your help. Again.

I want to enter the month and day portions only of a date into a table
field. The idea is that I'll use the information later to generate a list
of
birthdays by using a query (all the birthdays in January, all in

February and so forth). The organization doesn't ask for dates of birth - the only information available is the day and month - 8/4, for example is my

birthday
and that's all that would be entered in the table.

I've fiddled with this a good deal and it seems that no matter what the
input mask, Access wants to put the current year into the field as well.

I'm
concerned that this will somehow cause a problem in the future, I just

don't
know how.

Is it possible to enter just the month and date using an input mask, or

does
this have to be done as text, with the attendant problem of ordering the
birthdays in date order, since the sort then seems to be done only on the characters before (to the left of) the "/" character...

Thanks.
Steve E.



Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.