Current Year inserted

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Using Access 2000. I want to have a field on my report that automatically
inserts the current year. What do I type in my text box to get that?

Thanks,
Linda
 
Use an expression similar to this as the Control Source of that textbox:

=Year(Date())
 
Thank-you. I am pretty sure access has some of these commonly used/needed
expressions but I can't seem to find it. Is there a list somewhere?

Thanks,
Linda
 
Hmmm....

Many/most of them are in VBA Help, but aren't always easy to find unless you
know what you seek.

You could look at the Object Browser (when VBEditor is open) and select the
VBA option in the dropdown list. That'll show you the functions, objects,
etc. that are in VBA.

Or continue to build up your repetoire by asking questions here.... < g >
 
Back
Top