Putting Dates into a string

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

Guest

This is in the control source for a text box. Just trying to make everything
look neater. But it doesn't appear. Any suggestions?

="For Period: " + [Payment_Period_From] + " to " + [Payment_Period_To]
 
Assuming that fields [Payment_Period_From] and [Payment_Period_To]
exist in the Report's source query, this should work as long as the
contents of one or both the fields is not Null. In that case, the Null
value will propagate and the Control value will be Null. To avoid Null
propagation, you should use "&" instead of "+". Nulls will then
effectively be replaced by "".

This is in the control source for a text box. Just trying to make everything
look neater. But it doesn't appear. Any suggestions?

="For Period: " + [Payment_Period_From] + " to " + [Payment_Period_To]
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top