Current year in unbound text box 1

[jer007]

This sounds easy but for some reason I can't seem to get it to work.

I have an unbound text box. When the form is opened I want it to display the current year. I do not want the month or day in this text box.

If you know how to do this I'd appriciate the help

Thanks

 

[GingerR]

What have you tried so far that doesn't work?

 

[TheAceMan1]

How are ya jer007 . . . . .

In the [blue]ControlSource[/blue] of the textbox, try the following:

[blue] = Format(Now(),"yyyy")[/blue]

See Ya! . . . . . .

 

[jer007]

Thanks AceMan!

I new it was embarrassingly simple. It gets so cold here in Canada the brain just doesn't fire at full speed.

Thanks again!

 

[GingerR]

Jer007--you can look in HELP under DATE FORMATS to get all kinds of functions like that.

I would use

= Year(Date())

Aceman--i was gonna try to teach Jer to fish!!

 

[TheAceMan1]

How are ya GingerR . . . . .

[purple]You have the power![/purple]

[blue]Merry Christmas & Happy NewYear![/blue] ;-)

See Ya! . . . . . .

 

[jpstroud]

Yet a third option is to try =Year(Now()).

(also available, Day(), Month())