Date Format Issue

[FA]

I have a question regarding Date Format.
My data format on one of the field "TestBeginDate" on main form is
99/99/0000;0;_
I have a command button which opens the second form taking the same
date from main form to another form. I want the format of the date to
be changed on when it appears on the second form. i want the format to
be "yyyy,mm,dd" on the second form. So for instance if the date on the
main form is 01/21/2006, i want this date to apear like 2006/01/21 on
the second form. I tried the date format in the property of this field
on the second form like
= Format(TEST_BEGIN_DATE,"yyyy,mm,dd") but it didnt work.

If any one know how to do it please let me know.

Thanks
Moe

 

[John Spencer]

In form's design view
-- Select the control
-- Set the control's format property to yyyy,mm,dd