Conditional Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top