Help,
I have a text box with this info, but I want both the Start and End date to
be formatted with the mmm,yyy format.
Can someone help me with this code please.

="Performance Information " & [Enter a User Name] & "
for the period between " & [Enter a Start Date] & " and " & [Enter an End
Date] &" Format ([Enter a Start Date],"mmm,yyyy")

Thank you.
Judy

Try

="Performance Information " & [Enter a User Name] &
" for the period between " &
Format([Enter a Start Date], "mmm,yyyy") &
" and " & Format ([Enter an End Date],"mmm,yyyy")

(all on one line, of course)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"JudyT" <(E-Mail Removed)> wrote in message
news:F366F0B4-685E-486F-B2E9-(E-Mail Removed)...
> Help,
> I have a text box with this info, but I want both the Start and End date
> to
> be formatted with the mmm,yyy format.
> Can someone help me with this code please.
>
> ="Performance Information " & [Enter a User Name] & "
> for the period between " & [Enter a Start Date] & " and " & [Enter an End
> Date] &" Format ([Enter a Start Date],"mmm,yyyy")
>
> Thank you.
> Judy