MS Access conditional formatting, how to add text if date field is blank?

Posted on 2011-04-21
Last Modified: 2012-05-11
I have a date field that is sometimes blank, I have conditional formatting applied that changes the background color bu I would like to add some text as well. Since the textbox is of type Date I don't see how I can do this. Any ideas?
Question by:AkAlan
    LVL 119

    Accepted Solution

    fwiw, you can use an additional label or unbound textbox to display the text

    what is the real intention here?
    LVL 44

    Expert Comment

    Have you ever used the Controltip text property of a text box?   When you hover over a text box (without clicking), after a few seconds, the text appears in a box just below or above the text box.  
    LVL 6

    Author Comment

    Thanks for the replies, the intention is to give the user a visual que that means something, as opposed to just a different background when the date field is blank. I like the idea of the label and will try it.
    LVL 26

    Expert Comment

    As noted, you could put a label with color and text behind the control and in the current event and got focus events, you can toggle the control's back style from normal to transparent and the label from visible to invisible.

    In Access 2003, at least, you use the Format|Send to back command to position the label in behind the control to make that part of it play nice

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now