Textbox with fixed value

[an]

Hi!

I have a Textbox where the age is calculated, in function of the birth date.
I would like, in another Textbox, show us de age but not actualized with the
time,
to remain the age in record date.
Is possible to fix this value, please?
Thank you in advance.
an

 

[Allen Browne]

If you have a field named Birth Date, and a function Age(), you can set the
ContolSource of you other text box to:
=Age([Birth Date])

If you don't have the Age() function, there's one here:
http://allenbrowne.com/func-08.html

 

[an]

Ok, AB.

Thank you very much.
an

If you have a field named Birth Date, and a function Age(), you can set the
ContolSource of you other text box to:
=Age([Birth Date])

If you don't have the Age() function, there's one here:
http://allenbrowne.com/func-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi!

I have a Textbox where the age is calculated, in function of the birth
date.
I would like, in another Textbox, show us de age but not actualized with
the
time,
to remain the age in record date.
Is possible to fix this value, please?
Thank you in advance.
an