If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
validation rule
I would appreciate if someone can help me with the validation rule for medium
date on a table design property e.g. 30-Jun-2008. |
#2
|
|||
|
|||
validation rule
You are mixing terms. Medium Date is a display format, not a validation.
A validation would be something like -- #1/1/2000# - Any date after beinning of the millennium =Date() - Today or eariler "AsquareDC" wrote: I would appreciate if someone can help me with the validation rule for medium date on a table design property e.g. 30-Jun-2008. |
#3
|
|||
|
|||
validation rule
thx for your response.
I do have my date field formatted as medium date. I would like to force data entry on the medium date format as well otherwise the record should not be accepted. I have been such errors as ####################### because data was incorrectly entered. So to get over this, i reckon that have a validation rule which would only accept entry into this date field according to the medium date format. Pls advise. "KARL DEWEY" wrote: You are mixing terms. Medium Date is a display format, not a validation. A validation would be something like -- #1/1/2000# - Any date after beinning of the millennium =Date() - Today or eariler "AsquareDC" wrote: I would appreciate if someone can help me with the validation rule for medium date on a table design property e.g. 30-Jun-2008. |
#4
|
|||
|
|||
validation rule
If your field is datatype DateTime then Access will accept many different
formats for data entry but only display that which you set as format for your query, for, or report. "AsquareDC" wrote: thx for your response. I do have my date field formatted as medium date. I would like to force data entry on the medium date format as well otherwise the record should not be accepted. I have been such errors as ####################### because data was incorrectly entered. So to get over this, i reckon that have a validation rule which would only accept entry into this date field according to the medium date format. Pls advise. "KARL DEWEY" wrote: You are mixing terms. Medium Date is a display format, not a validation. A validation would be something like -- #1/1/2000# - Any date after beinning of the millennium =Date() - Today or eariler "AsquareDC" wrote: I would appreciate if someone can help me with the validation rule for medium date on a table design property e.g. 30-Jun-2008. |
#5
|
|||
|
|||
validation rule
On Tue, 30 Jun 2009 14:53:01 -0700, AsquareDC
wrote: thx for your response. I do have my date field formatted as medium date. I would like to force data entry on the medium date format as well otherwise the record should not be accepted. I have been such errors as ####################### because data was incorrectly entered. So to get over this, i reckon that have a validation rule which would only accept entry into this date field according to the medium date format. The date is NOT stored in medium date format, or in any other format. A Date/Time value is actually stored as a number, a count of days and fractions of a day (times) since midnight, December 30, 1899. As such you can have a date stored in a table and display it in one place as 6/30, in another textbox as 30-June-2009, and in another as 06/30/2009. It makes no sense to speak of "storing the date in medium date format". If you really want to annoy your users you can use a fixed length format such as mm/dd/yyyy and use an Input Mask "00/00/0000" to force them to enter six numeric digits. This will require them to type 07012009 (six keystrokes) instead of 7/1 (three) to get exactly the same value (39995.0000000000) stored in the table, but it will control what they enter. Input masks aren't useful if you use a variable length format such as "May 13" or "December 21", however - even though these are acceptable entries to a date field. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|