Add description for a text box in Access forms

  • Thread starter Thread starter chanu
  • Start date Start date
C

chanu

I have a text box where the user is expected to enter dates.But i want to
display a message < dd-mm-yyyy> highlighted with a blue blackground to give a
visual clue that only such a date format will be accepted.
 
Thank you for your help. In an attempt to simplify my query, I have
oversimplified it to mean a totally different thing. Actually my doubt is
FORMAT A NULL VALUE WITH CUSTOM MESSAGE.
FROMDATE TODATE MONTHLY RATE OF PAY
01-01-2009 30-09-2009 15000
01-10-2009 30-11-2009 17000
01-12-2009 20000

The user actually enters the pay rate for different periods. The pay rate
for the present period is Rupees 20,000 per month. We don’t know how long
the present pay rate will be continued. So, the TODATE field will be left
NULL. Instead of leaving it blank, I want to display a message:
<UPTO PRESENT>
This message should be the default value for TODATE field in the form
assuming that the rate the user enters now would be continued up to
present. So that the user need not scratch his head what to fill in the
TODATE field if he has no clue when this rate would end.
 
Back
Top