Custom Input Mask

[Serious_Practitioner]

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.

[PC Datasheet]

Re: Custom Input Mask

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(DO B),"00") & "/" & Format(Day(DOB) ,"00")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Serious_Practi tioner" <Serious_Practi tionerNOSPAM@at t.net> wrote in message
news:ti9Zc.2844 29$OB3.35184@bg tnsc05-news.ops.worldn et.att.net...[color=blue]
> 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[/color]
of[color=blue]
> 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[/color]
birthday[color=blue]
> 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.[/color]
I'm[color=blue]
> concerned that this will somehow cause a problem in the future, I just[/color]
don't[color=blue]
> know how.
>
> Is it possible to enter just the month and date using an input mask, or[/color]
does[color=blue]
> 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.
>
>
>
>
>[/color]

[Serious_Practitioner]

Re: Custom Input Mask

Thank you...that works just fine!


Steve E.




"PC Datasheet" <nospam@nospam. spam> wrote in message
news:nvaZc.7523 $JT3.3954@newsr ead3.news.atl.e arthlink.net...[color=blue]
> Include the DOB and Birthday fields in your table. On your data entry[/color]
form,[color=blue]
> include both fields. Make DOB visible and Birthday not visible. Put the
> following code in the AfterUpdate event of DOB:
> Me!Birthday = Format(Month(DO B),"00") & "/" & Format(Day(DOB) ,"00")
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> resource@pcdata sheet.com
> www.pcdatasheet.com
>
>
> "Serious_Practi tioner" <Serious_Practi tionerNOSPAM@at t.net> wrote in[/color]
message[color=blue]
> news:ti9Zc.2844 29$OB3.35184@bg tnsc05-news.ops.worldn et.att.net...[color=green]
> > 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[/color][/color]
list[color=blue]
> of[color=green]
> > birthdays by using a query (all the birthdays in January, all in[/color][/color]
February[color=blue][color=green]
> > and so forth). The organization doesn't ask for dates of birth - the[/color][/color]
only[color=blue][color=green]
> > information available is the day and month - 8/4, for example is my[/color]
> birthday[color=green]
> > 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.[/color]
> I'm[color=green]
> > concerned that this will somehow cause a problem in the future, I just[/color]
> don't[color=green]
> > know how.
> >
> > Is it possible to enter just the month and date using an input mask, or[/color]
> does[color=green]
> > 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[/color][/color]
the[color=blue][color=green]
> > characters before (to the left of) the "/" character...
> >
> > Thanks.
> >
> >
> > Steve E.
> >
> >
> >
> >
> >[/color]
>
>[/color]