Add description for a text box in Access forms


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.
 
Ad

Advertisements

C

chanu

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.
 

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