Between Dates

[Rjconrep]

I have a text box on a vacation report that holds a beginning date and a text box which holds an end date.
Beginning date is the beginning of vacation
End date being the end of vacation.
I have another text field to show that the person is on vacation but I don't want it to show until the beginning date equals the current date and I want the same text block to equal nothing when the current date equals the End date. I know that this is probably a simple statement but it is not coming to me. I am drawing a blank.
HELP!

 

[Rick39]

Maybe something like:

Dim mydate As Date
mydate = DATE
If mydate >= BeginingDate And mydate <= EndDate Then
'Do something to the vacation box
Else:
'Do something else to the vacation box
End If