Current Year inserted

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
 
K

Ken Snell

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

=Year(Date())
 
L

Linda

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
 
K

Ken Snell

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 >
 
Top