Hi
Have just updated to Office 2013 (big mistake) and have designed a Form in Access, most fields of which just have simple text or number values when entered. For some fields I have set up a formula to define the value, which then displays fine in the form. In the related table however, all of the fields with a formula don't display. The usual text values etc display fine.
For example, I want it to calculate a date 8 weeks before the value entered in the StartDate field and the expression is =DateAdd("ww",-8,[StartDate]) This formula is the Control Source. Comes up fine with the right date in the Form, but blank in the table.
Any ideas what I'm doing wrong? I used to be able to do this years ago but am a bit rusty now...and don't really know my way around it any more.....
Thanks