Date function not recognised in Access 2007

[sashapixie]

Hello There

I have a report with the following conditional formatting in a report in access 2013.

Expression Is [Follow up Date]=Date()

I have Access 2013 and this works fine, when I open the database in a colleague's 2007 version of access, when I run the report a parameter box appears for Date and no conditional formatting works.

I have searched the net but cannot find anything on this issue.

Any help would be greatly appreciated.

Thanks

 

[dlearyfun]

Sasha; what is "Follow up Date". Is it the name of a field? Where is the expression being used? In a control on the report or in the query for the report? When you put something in square brackets like that you are telling Access it is either a FieldName or it is a parameter in a query. I am surprised it works in Access2013 but then I am not sure how you are using it. If it is a field name in an expression in a control Ie: ControlSource property, it should be in parentheses like ([Follow up Date]) = Date()

 

[sashapixie]

Hello dlearyfun

"Follow up Date" is the field name. This field appears in a query which is the data source for the report. I will input the brackets and see if this fixes my issue in Access 2007.

Thanks for your response.

 

[sashapixie]

I still have the parameters pop up box for Date appearing

 

[xenou]

One strange error (occasionally) is that Visual Basic is not referenced.

1) Alt-F11 to open the visual basic editing environment
2) Tools | References to view references
3) make sure that Visual Basic for Applications is checked (usually it is at the top of the list, which is probably where it should be).