Very Computer

I am trying to help someone convert their database to handle Year 2000
dates. I changed the Picture of each date field to #[#]/#[#]/####. When
I enter a date like 4/8/1997 it displays in the table as 4/8/97, but if
I put in a date like 4/8/2010 it displays as 4/8/2010 in the table. All
of the forms that they have set up are only displaying 8 date characters
including the "/'s" (i.e 4/8/20 and 4/8/97). This is fine for the 1900
dates but it truncates the 2000 dates. I know that you can specify on a
report which format to display it in like mm/dd/yyyy or mm/dd/yy. Is
there a way to do this on a form. Most of their forms cannot be
reformated to accept a 10 character date because there simply isn't
enough room on the form.

Is there a solution or workaround that won't require a major reworking
of their 200+ forms?

Thanks for any suggestions!

: I am trying to help someone convert their database to handle Year 2000
: dates. I changed the Picture of each date field to #[#]/#[#]/####. When
: I enter a date like 4/8/1997 it displays in the table as 4/8/97, but if
: I put in a date like 4/8/2010 it displays as 4/8/2010 in the table. All
: of the forms that they have set up are only displaying 8 date characters
: including the "/'s" (i.e 4/8/20 and 4/8/97). This is fine for the 1900
: dates but it truncates the 2000 dates. I know that you can specify on a
: report which format to display it in like mm/dd/yyyy or mm/dd/yy. Is
: there a way to do this on a form. Most of their forms cannot be
: reformated to accept a 10 character date because there simply isn't
: enough room on the form.

The way you select a date format for a form is same way that you
select it for a report: right click, select the "..." and choose
a date format (I think you'll have to create your own custom format
for mm/dd/yyyy).

But if you're problem is finding room for the two extra characters,
I don't know what makes you think anyone can come with a way to fit
ten characters in the space of eight.  You can always make the font
smaller or narrower, if it's still readable; other than that, you'll
have to come up with some way to reduce the clutter on the form.
If you're using version 7, tabbed notebook pages might be a way
to cut the clutter.
--
=================================================================

=================================================================