条件格式中的Synthax错误 [英] Synthax error in Conditional formatting

问题描述

我希望将条件Fomatting应用于子表单的日期控件，如果它的日期早于另一个表格（表单）中的日期。我在Expression中使用以下代码：DateDiff（" s"，DLookUp（" [LastMeeting]"，" LastMeetingDate"），[DateOfInfoAdded]）> 0

但是继续获得语法错误消息。知道我做错了吗？

I want to apply Conditional Fomatting to a sub form''s date control when it''s of earlier date than a date in another table (form). I use following code in Expression is: DateDiff("s",DLookUp("[LastMeeting]","LastMeetingDate"),[DateOfInfoAdded])>0
but keep getting a syntax error message. Any idea what I''m doing wrong?

推荐答案

我想将条件Fomatting应用于子表单'日期控制的时间早于另一个表格（表格）中的日期。我在Expression中使用以下代码：DateDiff（" s"，DLookUp（" [LastMeeting]"，" LastMeetingDate"），[DateOfInfoAdded]）> 0

但是继续获得语法错误消息。知道我做错了吗？

I want to apply Conditional Fomatting to a sub form''s date control when it''s of earlier date than a date in another table (form). I use following code in Expression is: DateDiff("s",DLookUp("[LastMeeting]","LastMeetingDate"),[DateOfInfoAdded])>0
but keep getting a syntax error message. Any idea what I''m doing wrong?

您的语法实际上是不正确的。尝试：

Your syntax, is in fact, incorrect. Try:

展开 | 选择 | Wrap | 行号

您的语法实际上是不正确的。尝试：

Your syntax, is in fact, incorrect. Try:

展开 | 选择 | Wrap | 行号

"需要删除第二行：


DCount（[LastMeeting]，LastMeetingDate，[DateOfInfoAdded]< =＃"& Forms！CompoundObservations！[DateOfInfoAdded]&"＃"）> 0


还要确保您的应用程序在具有美国区域设置的计算机上运行。默认计算机日期格式为dd-mm-yyyy会导致麻烦...


Nic; o）

The " on the second line needs to be removed.:

DCount("[LastMeeting]", "LastMeetingDate", "[DateOfInfoAdded] < =#" & Forms!CompoundObservations![DateOfInfoAdded] & "#") > 0

Also be sure that your application works on a computer with the US regional settings. Having a default computer date format of dd-mm-yyyy will cause trouble...

Nic;o)

这篇关于条件格式中的Synthax错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！