I am trying to change the format/input mask of a field so that I type in the
4 digit year and it displays the 4 digit year.

Format: yyyy
Input mask: 0000

It doesn't work.
When I type in a 4 digit year it gives me an error message:
"The value ypu entered isn't valid for this field. For example, you have
entered text in a numeric field or a number that is larger than the field
size setting permits

--
-CLSWL

A date/time data type can only hold a full date/time value, not just the
year. Change the field's data type to an Integer Number. You won't need to
format it, just use an input mask to ensure that 4 digits are entered.

Ken Sheridan
Stafford, England

"CLSWL" wrote:

> I am trying to change the format/input mask of a field so that I type in the
> 4 digit year and it displays the 4 digit year.
>
> Format: yyyy
> Input mask: 0000
>
> It doesn't work.
> When I type in a 4 digit year it gives me an error message:
> "The value ypu entered isn't valid for this field. For example, you have
> entered text in a numeric field or a number that is larger than the field
> size setting permits
>
> --
> -CLSWL