CODEWITHSUNDEEP
ms-access
Shyra
Shyra

Reputation:

Alter Access Field Formats

I have a field that is formatted as a short date. When the field is empty, how do I get text to appear in the field as guidance? For example, I want the field to read "DATE RECEIVED" when empty, but, when completed force a short date entry.

Upvotes: 0

Views: 26

Answers (1)

Gustav
Gustav

Reputation: 55806

Adjust the Format property of the textbox displaying the value to:

yyyy-mm-dd;;;"DATE RECEIVED"

Upvotes: 1

Related Questions