A
an
Hi!
In continuous form I have 4 Textboxes: Start1 (time), A1 (text), Start2
(time) and A2 (text).
I have attemped without success, with the Conditional Formatting in textbox
A2 to pass to red the content in this textbox when content A2=content A1 and
time in textbox Start1= time in textbox Start2 or time in textbox Start2 +-
30 minutes, relatively to time in Start1.
I used Expression is, in CF in textbox A2, the next:
(Me.A1=Me.A2) And (Me.Start1 Between DateAdd("n";-30;Me.Start2) And
DateAdd("n";30;Me.Start2))
Thanks in advance any help.
an
In continuous form I have 4 Textboxes: Start1 (time), A1 (text), Start2
(time) and A2 (text).
I have attemped without success, with the Conditional Formatting in textbox
A2 to pass to red the content in this textbox when content A2=content A1 and
time in textbox Start1= time in textbox Start2 or time in textbox Start2 +-
30 minutes, relatively to time in Start1.
I used Expression is, in CF in textbox A2, the next:
(Me.A1=Me.A2) And (Me.Start1 Between DateAdd("n";-30;Me.Start2) And
DateAdd("n";30;Me.Start2))
Thanks in advance any help.
an