Display month and year on form

[Darren26]

I have a reports form where the user can enter enter a from date and to date for the report criteria. I have an unbound field on the report which i want to display the month and maybe the year in which this date criteria is in. This will be needed to display on the actual form. Say if the date range is between 01/01/05 and 31/01/05. I need the field to say January 05.

Hope this makes sense and can be done

 

[RuralGuy]

MonthName(Month(FromDate)) & " " & Year(FromDate)

 

[Darren26]

Thanks for that, it does the trick

 

[RuralGuy]

Glad I could help.

 

[Darren26]

Right, now for the next problem

It works fine on my machine, but when i use it on another machine the text box comes back saying Name# instead of the month.

Any idea why?

 

[ghudson]

What about using the Format() function?

Format([YourFieldNameHere],"mmmm yy")

 

[RuralGuy]

Darren, I would check for "Missing References" on the other machine.