Text Box Control Source: Field and Expression

[cunninghamsa]

Merry Christmas to All,

I've just come across a most annoying situation in my reports. Previously, one of the text boxes contained a date calculated from ReceivedDate + 14. Now, I've complicated things by adding an expression to allow for five different possibilities: received date +7, >7 to14, >14to21, etc. If I leave the record source to the name of the field, the previous entries show up but not the results of the calculated expression. If I enter the expression, I get the new data but now the old data.

Now, I want to have my cake and eat it too. Is there any way I can accomplish this?

 

[WayneRyan]

cunninghamsa,

You could make the source for the textbox a public function. If it
has a value, leave it alone, otherwise calculate it.

Wayne