calculated field in form

[awake2424]

I am trying to add a calculated Textbox to a form for DueDate

The below formula gives a #Type! error

Control Source Formula in DueDate:

Using the name of the textbox

=IIf(IsNull([Text1186]+21),0,([Text1186]+21))

Using the control source

=IIf(IsNull([RecieveDate]+21),0,([RecieveDate]+21))

Basically just trying to add 21 days from RecieveDate or Text1186.

Thank you .

 

[MarkK]

It could be that the type of your field is a string, and as a result your addition fails with a type mismatch error. What is the datatype of [RecieveDate] in the table?

 

[awake2424]

The data type is short text. Thank you .