need function help

[foolishone]

I need some help on changeing the properties of a field which is called "DateJoined" but was imported into table with this format 20011909. Can someone help me with an access function or expression to get the result 2001/19/09 on my form.

Thank you, ken

 

[shacket]

In the Input Mask of the control on the form, put the following:

####"/"##"/"##

 

[foolishone]

Thank You very much it worked just fine

ken