Recent content by MarcVS

I had to change it to "=DateAdd('d',-1,DateAdd('m',9," & Me.datEffectieveStartdatumIn & "))" but the result is not what was expected: (01/01/1900) So I changed it to "=DateAdd('d',-1,DateAdd('m',9,#" & Me.datEffectieveStartdatumIn & "#))" And now it works. Thank you for your help.

>Me.TextBox.ControlSource = "=DateAdd(""w"";1;Date())" This gave the same error >maybe change the semi colon to comma. That worked. But... The formula is more complex, in fact it is: Me.TextBox.ControlSource =...

I'm trying to set the ControlSource of a TextBox in VBA. Normally this is simple: Me.TextBox.ControlSource = "=Date()" But... I need to use the DateAdd function: Me.TextBox.ControlSource = "=DateAdd('w';1;Date())" This gives an error: 'the syntax of the expression you gave is invalid' the...