Date Heading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Right now I have a 2 text boxes. One has "=Format$([Type Start Date],"mmmm
d"", ""yyyy",0,0)" for the control source and the other has "=Format$([Type
End Date],"mmmm d"", ""yyyy",0,0) for the control source. In between the 2
text boxes I have a label box saying "through". How can I combine the 2 text
boxes and label? Thanks!
 
Create one text box and in the control source write

=Format$([Type Start Date],"mmmm d"", ""yyyy",0,0) & " through " &
Format$([Type End Date],"mmmm d"", ""yyyy",0,0)
 
Ofer,

Thank you so much for your help! I knew it was something like that, but
I couldn't get it just right for Access. Thanks again for your help!

Tandy
 
Ofer,

Sorry to bother you, but I was wondering if you could help me again
with a similar header. I have a label with saying "Monthly ER Time for" and a
text box that has "=Format$([Type Start Date],"mmmm yyyy",0,0)" for its
control source. How do I combine them? Thank you so much!
 
Try this

="Monthly ER Time for " & Format$([Type Start Date],"mmmm yyyy",0,0)

always start with equal, and the join any string with a & symbol.
 
Ofer,

Ok, now I am understanding how to put these together. Thank you for
explaining it so I don't have to keep bothering people! Thank you again for
your help, I really appreciate it!

Tandy
 
Back
Top