I want Access (97) to calculate somebody's age. I know you
can do that by setting the Control Source property of a
textbox to

=DateDiff("yyyy",[Date],Date())+(Format([Date],"mmdd")
>Format(Date(),"mmdd"))

but that will "just" display the person's age in years
whereas I'm looking for months as well.

Anybody has an idea how to do this without including a
macro?

Karen

Do a search. This was answered within the last three weeks or so. I
remember seeing it posted.

Rick B


"Karen" <(E-Mail Removed)> wrote in message
news:090e01c46e6d$c69d8880$(E-Mail Removed)...
I want Access (97) to calculate somebody's age. I know you
can do that by setting the Control Source property of a
textbox to

=DateDiff("yyyy",[Date],Date())+(Format([Date],"mmdd")
>Format(Date(),"mmdd"))

but that will "just" display the person's age in years
whereas I'm looking for months as well.

Anybody has an idea how to do this without including a
macro?

Karen

On Tue, 20 Jul 2004 08:25:23 -0700, Karen wrote:

> I want Access (97) to calculate somebody's age. I know you
> can do that by setting the Control Source property of a
> textbox to
>
> =DateDiff("yyyy",[Date],Date())+(Format([Date],"mmdd")
>>Format(Date(),"mmdd"))
>
> but that will "just" display the person's age in years
> whereas I'm looking for months as well.
>
> Anybody has an idea how to do this without including a
> macro?
>
> Karen

You'll need code!

See Doug Steele's code at:
http://members.rogers.com/douglas.j....iff2Dates.html

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

In addition to the fine code on Doug's site, there's also this:
http://www.pacificdb.com.au/MVP/Code/Age2.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyT...764559036.html


"fredg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 20 Jul 2004 08:25:23 -0700, Karen wrote:
>
> > I want Access (97) to calculate somebody's age. I know you
> > can do that by setting the Control Source property of a
> > textbox to
> >
> > =DateDiff("yyyy",[Date],Date())+(Format([Date],"mmdd")
> >>Format(Date(),"mmdd"))
> >
> > but that will "just" display the person's age in years
> > whereas I'm looking for months as well.
> >
> > Anybody has an idea how to do this without including a
> > macro?
> >
> > Karen
>
> You'll need code!
>
> See Doug Steele's code at:
> http://members.rogers.com/douglas.j....iff2Dates.html
>
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.