Silly Question

  • Thread starter Thread starter Robert Sykes
  • Start date Start date
R

Robert Sykes

I have a report with an unbound label, what I want it to say is "New members
for 'Month'", being the current month. I can get it to state the what number
is i.e "New members for 12" but I would like it to say "New Members for
December", how is this done?

This is what i have in the control:
="New Members for" & Month(Now())

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.
 
Change the label to a textbox, then use this expression as the textbox's
Control Source:

="New Members for " & Format(Date(), "mmmm")
 
Oops. That would only give you "Dec". The following will spell out the
entire month.



="New Members for" & Format(Date(),"mmmm")
 
Back
Top