Date format in text box with VB coding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JudyT - 20 Jul 2007 14:10 GMT

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

Reply to this Message

Douglas J. Steele - 20 Jul 2007 14:29 GMT

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)

Signature

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

> Help,
> I have a text box with this info, but I want both the Start and End date
[quoted text clipped - 8 lines]
> Thank you.
> Judy

Reply to this Message