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

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

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

It would be much better in the long run to store the date as a date/time data type. You can either do the conversion again with an import spec that specifies the date format so that Access can interpret it properly or you can add a new column to the table and run an update query to convert the text string to a date. Once the text string has been converted to a date, you can delete the text string column.

Thank You very much it worked just fine
http://www.access-programmers.co.uk/ubb/smile.gif ken