Where it will be the error, please?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top