Embedding Date field into text box

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

Guest

I have a report in which I am want to place a calculated date field in a text box. The text box would end up in the middle of text and need to have the text adjust to the date shown. 1) is this possible in Access 2000? 2) what is the process to complete this task?
 
Kirschbaum said:
I have a report in which I am want to place a calculated date field in a text box. The text box would end up in the middle of text and need to have the text adjust to the date shown. 1) is this possible in Access 2000? 2) what is the process to complete this task?
Click to expand...


That's too confusing for me to be sure what you want, but it
could be as simple as using an expression in a text box.
E.g.

="Pay by " & Format(DateAdd("d", 30, [SaleDate]), "d mmm
yyyy") & " to avoid penality"
 
Sorry, I did not explain my problem very well. I try one more time. I have a paragraph of text with a ever changing date (due date) in the middle of that text.
I want to automate the calculation of that date. So the text box would read like: blah blah blah return by [today's date + 14 days] blah blah blah. I hope that is a clearer explaination of my problem.

Marshall Barton said:
Kirschbaum said:
I have a report in which I am want to place a calculated date field in a text box. The text box would end up in the middle of text and need to have the text adjust to the date shown. 1) is this possible in Access 2000? 2) what is the process to complete this task?
Click to expand...


That's too confusing for me to be sure what you want, but it
could be as simple as using an expression in a text box.
E.g.

="Pay by " & Format(DateAdd("d", 30, [SaleDate]), "d mmm
yyyy") & " to avoid penality"
Click to expand...
 
Kirschbaum said:
Sorry, I did not explain my problem very well. I try one more time. I have a paragraph of text with a ever changing date (due date) in the middle of that text.
I want to automate the calculation of that date. So the text box would read like: blah blah blah return by [today's date + 14 days] blah blah blah. I hope that is a clearer explaination of my problem.
Click to expand...

It still seems like my earlier example does what you want?

="blah blah blah return by " & Format(DateAdd("d", 14,
Date()), "d mmm yyyy") & " blah blah blah."


Marshall Barton said:
That's too confusing for me to be sure what you want, but it
could be as simple as using an expression in a text box.
E.g.

="Pay by " & Format(DateAdd("d", 30, [SaleDate]), "d mmm
yyyy") & " to avoid penality"
Click to expand...
Click to expand...
 
Back
Top