Conditional Formatting Question

[Guest]

Can't seem to figure out why the conditional formatting of a txtBox
(txtTeeTime) whose control source is field (fldTeeTime) whose data type is
Date/Time doesn't work on a form when the same expression worked in a
previous form that (appears to me) to be exactly the same in terms of its
structure and behavour.

The code that did work on the other but doesn't on the current:
Expression is
[fldTeeTime]=#11:00:00 AM# Or [fldTeeTime]=#12:00:00 PM#

I did however get this to work on the current form but don't really know why?
Expression is
[fldTeeTime]="11:00:00 AM" Or [fldTeeTime]="12:00:00 PM"

Help in explaining this is much appreciated.

 

[Penguin]

Try looking at this link. It may give you some help.

http://www.mvps.org/access/datetime/index.html