i have formated the field to short date but i don't want the field to change on me when i click on it which happens at this point. thanks in advance.

Can try this:

If it's an unbound field, in the format line, do not pick short date, can type in mm/dd/yyyy or mm/dd/yy.

If it's a field bound to a table, you can chose short date then put this formatting in the input mask area of the table def to this:

99/99/00;0

If the form is referenced to a query, and the field is called date, do this in the column of the query:

NewDate: format([date],"mm/dd/yyyy")


Then put in the field called NewDate into your form.

Hope that helped.

Deb