var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Undefined Function Mid in Expression
I have written a statement within a select query that modifies the format of a date value form 00000000 to 00/00/0000
Date of Birth: IIf([Date_Of_Birth]="00000000","",DateValue(Mid([Date_Of_Birth],7,2) & "/" & Mid([Date_Of_Birth],5,2) & "/" & Mid([Date_Of_Birth],1,4)))
But receive the error:
Undefined Function Mid in Expression
Can anyone help?
Check your preferences...
or even your references
open a form in design mode, view the code and then tools | references
make sure that the VBA library is missing, and try to resolve any missing references