<div>
Many thanks for the input. &nbsp;Rather than highlight an existing field this gave me a new field which shows me the next time but that is absolutely fine and works A OK.<br />
<br />
I totally understand that the structure is not ideal but this situation requires that for each record there are 6 distinct times in a day so I have them as Time1, Time2 etc. Also, there are only 10 records so the performance hit is minimal.<br />
<br />
Again, thanks for the input.
</div>


<div>
you're welcome<br />
<br />
you can make NextTime hidden on the form and use a formula to compare for the conditional formatting of each time control if you want to highlight in-place. Performance will be better, though, if you like the NextTime displayed separately.<br />
<br />
have an awesome day,<br />
crystal
</div>


<div>
Gustav, thanks. I brought this code and and edited and it runs fine until it gets to the text box to be highlighted and the nit raises an error.<br />
<br />
Run-time error '91'<br />
Object variable or With block variable not set<br />
<br />
The line that has the issue is <i>Next Control = ThisControl</i><br />
<br />
At that point using the immediate window I can see that Next Control is Nothing
</div>


<div>
Ah, it should be:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42415625-1"><span>Set NextControl = ThisControl</span>
</code></pre>
Also the other line.<br />
<br />
/gustav
</div>


<div>
Worked a charm. Many thanks to both you and crystal
</div>


<div>
you're welcome ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
I have 6-7 fields displayed on an Access 2016 form. Each field contains a datetime value (only a time) and I would like to highlight the field that is nearest to the present time (BUT ahead of the current time). i.e. the next time to occur.<br />
<br />
For example:<br />
<br />
The fields are 02:00 &nbsp;06:00 &nbsp;10:00 &nbsp;14:00 &nbsp;18:00 &nbsp;22:00<br />
<br />
The time is now 9:35AM and so the field which will be highlighted will be the 10:00 field. It is the next time to occur.<br />
<br />
When the current time moves to 10:01AM then the 10:00 field would no longer be highlighted and the 14:00 one would be.<br />
<br />
'Highlighting' will be by meaning of changing the text box's Back Color property.
</div>
</div>


I have 6-7 fields displayed on an Access 2016 form. Each field contains a datetime value (only a time) and I would like to highlight the field that is nearest to the present time (BUT ahead of the current time). i.e. the next time to occur.

For example:

The fields are 02:00  06:00  10:00  14:00  18:00  22:00

The time is now 9:35AM and so the field which will be highlighted will be the 10:00 field. It is the next time to occur.

When the current time moves to 10:01AM then the 10:00 field would no longer be highlighted and the 14:00 one would be.

'Highlighting' will be by meaning of changing the text box's Back Color property.

Highlighting a datetime field on an Access 2016 form when it is close to current time.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.