Author Topic: MS Access formula result not showing in table  (Read 308 times)

Charlie Boy

  • Dreams in kilometers
MS Access formula result not showing in table
« on: January 24, 2014, 12:09:32 am »

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.....

Mojo is being awakened.