How to link a VB code to a textbox (in a form or report)

brunces

Registered User.
Local time
Today, 17:41
Joined
Sep 12, 2004
Messages
45
Friends,

Another doubt of mine. (Sorry, but I'm a real begginer.) :o

I want to calculate the age of a client, but you know it's not simply to do this:

=Date()-[DateOfBirth] & "years old"

For, depending on his date of birth and today's date, the calculation should be:

=Date()-[DateOfBirth]-1 & "years old"

So, I don't know how to do this, using a simple expression, inside a text box. If someone knows and can show me, I appreciate it very much. However, my doubt is another one...


I want to know how to link a VB code to a textbox. I mean, I want to calculate that age, using a VB code I found in Google, for example, but I don't know how to put its result inside a textbox (in a form or report). I know what to do, but I don't know HOW to do (where to click on, where to put the code, how to identify the code and link it to the textbox). It must be very simple, but I really don't know.

If someone could help me, I'd appreciate it. :D

Thank you so much for the attention.

Hugz.

Bruno
 

Users who are viewing this thread

Back
Top Bottom